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 Nov 16 at 14:56
excelguy
458
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 Nov 16 at 14:56
excelguy
458
Hard to tell without seeing your data... Can you please edit your question to include it?
– cybernetic.nomad
Nov 16 at 15:09
included my date column.. the rest are a few columns full of data.
– excelguy
Nov 16 at 15:50
What happens when you right-click on the chart andselect data? is the correct range selected?
– cybernetic.nomad
Nov 16 at 16:00
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
Nov 16 at 16:01
@PeterH thanks peter, that seemed to do the trick
– excelguy
Nov 16 at 16:16
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 Nov 16 at 14:56
excelguy
458
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 Nov 16 at 14:56
excelguy
458
asked Nov 16 at 14:56
excelguy
458
edited Nov 16 at 15:49
asked Nov 16 at 14:56
excelguy
458
asked Nov 16 at 14:56
excelguy
458
asked Nov 16 at 14:56
excelguy
458
458
Hard to tell without seeing your data... Can you please edit your question to include it?
– cybernetic.nomad
Nov 16 at 15:09
included my date column.. the rest are a few columns full of data.
– excelguy
Nov 16 at 15:50
What happens when you right-click on the chart andselect data? is the correct range selected?
– cybernetic.nomad
Nov 16 at 16:00
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
Nov 16 at 16:01
@PeterH thanks peter, that seemed to do the trick
– excelguy
Nov 16 at 16:16
add a comment |
Hard to tell without seeing your data... Can you please edit your question to include it?
– cybernetic.nomad
Nov 16 at 15:09
included my date column.. the rest are a few columns full of data.
– excelguy
Nov 16 at 15:50
What happens when you right-click on the chart andselect data? is the correct range selected?
– cybernetic.nomad
Nov 16 at 16:00
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
Nov 16 at 16:01
@PeterH thanks peter, that seemed to do the trick
– excelguy
Nov 16 at 16:16
Hard to tell without seeing your data... Can you please edit your question to include it?
– cybernetic.nomad
Nov 16 at 15:09
Hard to tell without seeing your data... Can you please edit your question to include it?
– cybernetic.nomad
Nov 16 at 15:09
included my date column.. the rest are a few columns full of data.
– excelguy
Nov 16 at 15:50
included my date column.. the rest are a few columns full of data.
– excelguy
Nov 16 at 15:50
What happens when you right-click on the chart and
select data? is the correct range selected?– cybernetic.nomad
Nov 16 at 16:00
What happens when you right-click on the chart and
select data? is the correct range selected?– cybernetic.nomad
Nov 16 at 16:00
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
Nov 16 at 16:01
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
Nov 16 at 16:01
@PeterH thanks peter, that seemed to do the trick
– excelguy
Nov 16 at 16:16
@PeterH thanks peter, that seemed to do the trick
– excelguy
Nov 16 at 16:16
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
Nov 16 at 15:09
included my date column.. the rest are a few columns full of data.
– excelguy
Nov 16 at 15:50
What happens when you right-click on the chart and
select data? is the correct range selected?– cybernetic.nomad
Nov 16 at 16:00
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
Nov 16 at 16:01
@PeterH thanks peter, that seemed to do the trick
– excelguy
Nov 16 at 16:16