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.

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




"Adam WK" <Adam (E-Mail Removed)> wrote in message
news:748099DD-697F-4CC3-9F3D-(E-Mail Removed)...
>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.