Dates Incorrect in Chart

[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

 

[Jon Peltier]

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

 

[Jim]

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

Jim

 

[Jon Peltier]

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

 

[Jim]

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

 

[Jon Peltier]

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