Excel reformatting a date axis to January

  • Thread starter Thread starter scoz
  • Start date Start date
S

scoz

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
 
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
 
Back
Top