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 Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. -
http://PeltierTech.com
_______
"Jim" wrote in message
...
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