Dates Incorrect in Chart

  • Thread starter Thread starter Jim
  • Start date Start date
J

Jim

I am creating a simple line chart with dates and values. The dates are of
the form 2-Apr-08 (ie custom format) but in the graph they display as
26-Apr-12. Note the data has dates every week but the graph displays these
all as 26-xxx-12 (where xxx= one of the months).
What is wrong - I am using Excel 2007
Thanks Jim
 
Are the dates in the sheet numeric dates, or text that looks like dates?
What's the number format of the axis tick labels?
Is it a date axis?

- Jon
 
Jon
The dates in the sheet are formatted as dd-mmm-yy and this is also the
format in the axis

Jim
 
Are the dates in the sheet numeric dates, or text that looks like dates?
Does the category axis reference for the series point to the right range in
the worksheet?

- Jon
 
Jon the dates in the sheet are numeric dates formatted as dd-mmm-yy and i do
calcuations with them so they are not text. And the axis reference for the
series points to that range of dates

Jim
 
Just checking that you understand, and you do.

Is this a problem on other charts as well? Can you build a duplicate chart
from scratch? Does it display correctly, or is it also faulty?

(In case you can't tell, I'm at a bit of a loss.)

- Jon
 
Back
Top