Excel Chart, Named Range, Exclude the word “Date”
up vote
0
down vote
favorite
I went the named range route when creating a chart because I want it to auto update whenever I add new data to the range.
However when I want the date listed on the x axis the word "date" is also being shown.
my named range is like so =OFFSET($A$1,0,0,COUNTA($A:$A)-1)
I have tried switching to A2, but then I get 0 data for 30/06/2016 ?
How can I exclude "Date" on my x axis ?
Here is my data:
microsoft-excel
asked 2 days ago
excelguy
438
add a comment |
up vote
0
down vote
favorite
I went the named range route when creating a chart because I want it to auto update whenever I add new data to the range.
However when I want the date listed on the x axis the word "date" is also being shown.
my named range is like so =OFFSET($A$1,0,0,COUNTA($A:$A)-1)
I have tried switching to A2, but then I get 0 data for 30/06/2016 ?
How can I exclude "Date" on my x axis ?
Here is my data:
microsoft-excel
asked 2 days ago
excelguy
438
Hard to tell without seeing your data... Can you please edit your question to include it?
– cybernetic.nomad
2 days ago
included my date column.. the rest are a few columns full of data.
– excelguy
2 days ago
What happens when you right-click on the chart andselect data? is the correct range selected?
– cybernetic.nomad
2 days ago
your named range for the axis should be=OFFSET($A$2,0,0,COUNTA(A:A)-1,1)and also ensure the named range for the series starts in ROW 2 also
– PeterH
2 days ago
@PeterH thanks peter, that seemed to do the trick
– excelguy
2 days ago
add a comment |
up vote
0
down vote
favorite
up vote
0
down vote
favorite
I went the named range route when creating a chart because I want it to auto update whenever I add new data to the range.
However when I want the date listed on the x axis the word "date" is also being shown.
my named range is like so =OFFSET($A$1,0,0,COUNTA($A:$A)-1)
I have tried switching to A2, but then I get 0 data for 30/06/2016 ?
How can I exclude "Date" on my x axis ?
Here is my data:
microsoft-excel
asked 2 days ago
excelguy
438
I went the named range route when creating a chart because I want it to auto update whenever I add new data to the range.
However when I want the date listed on the x axis the word "date" is also being shown.
my named range is like so =OFFSET($A$1,0,0,COUNTA($A:$A)-1)
I have tried switching to A2, but then I get 0 data for 30/06/2016 ?
How can I exclude "Date" on my x axis ?
Here is my data:
microsoft-excel
microsoft-excel
asked 2 days ago
excelguy
438
asked 2 days ago
excelguy
438
edited 2 days ago
asked 2 days ago
excelguy
438
asked 2 days ago
excelguy
438
asked 2 days ago
excelguy
438
438
Hard to tell without seeing your data... Can you please edit your question to include it?
– cybernetic.nomad
2 days ago
included my date column.. the rest are a few columns full of data.
– excelguy
2 days ago
What happens when you right-click on the chart andselect data? is the correct range selected?
– cybernetic.nomad
2 days ago
your named range for the axis should be=OFFSET($A$2,0,0,COUNTA(A:A)-1,1)and also ensure the named range for the series starts in ROW 2 also
– PeterH
2 days ago
@PeterH thanks peter, that seemed to do the trick
– excelguy
2 days ago
add a comment |
Hard to tell without seeing your data... Can you please edit your question to include it?
– cybernetic.nomad
2 days ago
included my date column.. the rest are a few columns full of data.
– excelguy
2 days ago
What happens when you right-click on the chart andselect data? is the correct range selected?
– cybernetic.nomad
2 days ago
your named range for the axis should be=OFFSET($A$2,0,0,COUNTA(A:A)-1,1)and also ensure the named range for the series starts in ROW 2 also
– PeterH
2 days ago
@PeterH thanks peter, that seemed to do the trick
– excelguy
2 days ago
Hard to tell without seeing your data... Can you please edit your question to include it?
– cybernetic.nomad
2 days ago
Hard to tell without seeing your data... Can you please edit your question to include it?
– cybernetic.nomad
2 days ago
included my date column.. the rest are a few columns full of data.
– excelguy
2 days ago
included my date column.. the rest are a few columns full of data.
– excelguy
2 days ago
What happens when you right-click on the chart and
select data? is the correct range selected?– cybernetic.nomad
2 days ago
What happens when you right-click on the chart and
select data? is the correct range selected?– cybernetic.nomad
2 days ago
your named range for the axis should be
=OFFSET($A$2,0,0,COUNTA(A:A)-1,1) and also ensure the named range for the series starts in ROW 2 also– PeterH
2 days ago
your named range for the axis should be
=OFFSET($A$2,0,0,COUNTA(A:A)-1,1) and also ensure the named range for the series starts in ROW 2 also– PeterH
2 days ago
@PeterH thanks peter, that seemed to do the trick
– excelguy
2 days ago
@PeterH thanks peter, that seemed to do the trick
– excelguy
2 days ago
add a comment |
active
oldest
votes
active
oldest
votes
active
oldest
votes
active
oldest
votes
active
oldest
votes
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f1376020%2fexcel-chart-named-range-exclude-the-word-date%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Hard to tell without seeing your data... Can you please edit your question to include it?
– cybernetic.nomad
2 days ago
included my date column.. the rest are a few columns full of data.
– excelguy
2 days ago
What happens when you right-click on the chart and
select data? is the correct range selected?– cybernetic.nomad
2 days ago
your named range for the axis should be
=OFFSET($A$2,0,0,COUNTA(A:A)-1,1)and also ensure the named range for the series starts in ROW 2 also– PeterH
2 days ago
@PeterH thanks peter, that seemed to do the trick
– excelguy
2 days ago