Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Date Scaling Issue
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Another Date issue. | Excel Worksheet Functions | |||
Using VLOOKUP with a Date and Time | Excel Discussion (Misc queries) | |||
Date conversion issue "^" symbol | Excel Discussion (Misc queries) | |||
Upper Case and date format issue | Excel Discussion (Misc queries) | |||
Date issue between Windows and Macintosh version | Excel Discussion (Misc queries) |