#1   Report Post  
Posted to microsoft.public.excel.charting
Adam WK
 
Posts: n/a
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Another Date issue. TimM Excel Worksheet Functions 1 November 17th 05 02:58 AM
Using VLOOKUP with a Date and Time Charles Excel Discussion (Misc queries) 4 September 20th 05 06:38 PM
Date conversion issue "^" symbol Shannon Excel Discussion (Misc queries) 1 May 4th 05 12:25 AM
Upper Case and date format issue Andy Tallent Excel Discussion (Misc queries) 3 April 8th 05 04:52 AM
Date issue between Windows and Macintosh version dlg1967 Excel Discussion (Misc queries) 4 January 19th 05 04:51 PM


All times are GMT +1. The time now is 04:09 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"