Excel reformatting a date axis to January
 

I am trying to create a chart using data which has date as one heading, 31
March 2005, when I create the chart, this seems to default to January and I
cannot find a way to set to the prcise date I am using.
I eventually want this chart in PowerPoint but..........

Any ideas? i am using Office 2007

Cheers all

Excel reformatting a date axis to January
 

It's probably defaulting to January 1 1900, day 1 in Excel's date system.
You are not providing valid dates for the chart to use as dates. Make sure
the apparent dates in the worksheets are numerical dates, not text labels,
then make sure the X values (category labels for the chart) refers to these
dates.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"scoz" wrote in message
...
I am trying to create a chart using data which has date as one heading, 31
March 2005, when I create the chart, this seems to default to January and
I
cannot find a way to set to the prcise date I am using.
I eventually want this chart in PowerPoint but..........

Any ideas? i am using Office 2007

Cheers all