View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Jon Peltier Jon Peltier is offline
external usenet poster
 
Posts: 6,582
Default Dates Incorrect in Chart

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