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. |
All times are GMT +1. The time now is 06:18 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com