Excel reformatting a date axis to January

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
 
J

Jon Peltier

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel 2007 charts: want to avoid zero values 1
Bar Chart in Excel 2010 does not display neither Horizontal axis labels, nor legend 0
Extending The Horiz. Axis Question ? 2
Excel 2010 - Line Chart with Mulitiple Data Sets 1
sideways stacked bar charts with line series on the same axis 0
import an Excel file to create a Gantt chart in Visio; Error:do not have the required mapped columns 0
Formatting pivot chart axis labels for dates 10
Overlaying 2 Data Series with Different Time (X) Axis 3

Top