Thread
:
Date Scaling Issue
View Single Post
#
2
Posted to microsoft.public.excel.charting
Kelly O'Day
Posts: n/a
Date Scaling Issue
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
wrote in message
...
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.
Reply With Quote