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.

enter image description here

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 ?

enter image description here

How can I exclude "Date" on my x axis ?

Here is my data:

enter image description here

edited 2 days ago

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 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

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.

enter image description here

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 ?

enter image description here

How can I exclude "Date" on my x axis ?

Here is my data:

enter image description here

edited 2 days ago

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 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

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.

enter image description here

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 ?

enter image description here

How can I exclude "Date" on my x axis ?

Here is my data:

enter image description here

edited 2 days ago

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.

enter image description here

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 ?

enter image description here

How can I exclude "Date" on my x axis ?

Here is my data:

enter image description here

microsoft-excel

edited 2 days ago

asked 2 days ago

excelguy

438

edited 2 days ago

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

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

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 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

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

add a comment |

active

oldest

votes

Your Answer

StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "3"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});

function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});

}
});

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

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

Name

Required, but never shown

active

oldest

votes

draft saved

draft discarded

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Post as a guest

Name

Required, but never shown

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Name

Required, but never shown

Name

Required, but never shown

This page is only for reference, If you need detailed information, please check here

搜尋此網誌

Bdtyktl