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


"Jim" wrote in message
...
Jon
The dates in the sheet are formatted as dd-mmm-yy and this is also the
format in the axis

Jim

"Jon Peltier" wrote:

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