Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
X Y Scatter Chart - Dates on X axis starting at 1900
Hi,
Attempting to create an X Y scatter chart with dates on the X axis, however, when the chart is displayed the dates start at 1/1/1900 instead of 01/15/08. I understand that Excel stores dates and times as a number representing the number of days since 1900-Jan-0, plus a fractional portion of a 24 hour day. However, is there a work around to this issue? Regards, Moms |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
X Y Scatter Chart - Dates on X axis starting at 1900
The problem is that Excel doesn't know what dates you want, so it is using
1, 2, 3, etc as its X values. This is caused by two things: 1. There is no X data range defined for the chart 2. The X data range contains text (which may appear to be in date format) rather than numeric dates. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ wrote in message ... Hi, Attempting to create an X Y scatter chart with dates on the X axis, however, when the chart is displayed the dates start at 1/1/1900 instead of 01/15/08. I understand that Excel stores dates and times as a number representing the number of days since 1900-Jan-0, plus a fractional portion of a 24 hour day. However, is there a work around to this issue? Regards, Moms |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
scatter chart x axis problem | Charts and Charting in Excel | |||
dates on scatter chart axis | Charts and Charting in Excel | |||
Scale on X & Y Axis of the scatter chart | Charts and Charting in Excel | |||
How do I add a second y-axis in an xy(Scatter) chart? | Charts and Charting in Excel | |||
the dates to label the x axis on the scatter chart won't print | Charts and Charting in Excel |