Date Scaling Issue

[Adam WK]

I have created an x-y scatter chart that has dates along the x-axis
(mm/dd/yy). The first date on the chart does not correspond to the first date
in my source data! When I go to change the min scale for the x-axis instead
of seeing a starting date I see a huge number(38790) that in no way seems to
corralate with my data (03/14/06) (note that my end point in this scaling
section is also a large number). My data cells that are used for this x-axis
data have been formated to be dates. I do want gaps between my dates that
match how much time has passed (if possible), but I do not want my data to
start a week early. I have had this issue when making charts before, any help
would be appreciated. Thank you very much.

 

[Kelly O'Day]

Adam:

The 38790 number you see if Excel's numerical equivalent to a date. It is
the number of days since Jan. 1, 1900.

The good news is that Excel will accept either the number (38790) or the
date(3/14/06).

So just enter the actual start and end dates that you want and the interval
in days. I have a few tips on XY trend charts @

http://processtrends.com/pg_charts_trend_chart.htm

...Kelly