X Y Scatter Chart - Dates on X axis starting at 1900

A

andyeali

Hi,

Attempting to create an X Y scatter chart with dates on the X axis,
however, when the chart is displayed the dates start at 1/1/1900
instead of 01/15/08. I understand that Excel stores dates and times
as a number representing the number of days since 1900-Jan-0, plus a
fractional portion of a 24 hour day. However, is there a work around
to this issue?

Regards,
Moms
 
J

Jon Peltier

The problem is that Excel doesn't know what dates you want, so it is using
1, 2, 3, etc as its X values. This is caused by two things:

1. There is no X data range defined for the chart

2. The X data range contains text (which may appear to be in date format)
rather than numeric 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

Make Y-axis values correspond to x- axis value 1
Scatter chart with categories on x-Axis 2
Excel 2010 - Line Chart with Mulitiple Data Sets 1
bar chart with dates on the x-axis 4
X Y (Scatter) Chart EXCEL 2007 1
Excel 2007: X-axis labeling 1
scatter chart won't accept primary axis 4
Trying to change x-axis date range 5

Top