View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
[email protected] andyeali@gmail.com is offline
external usenet poster
 
Posts: 2
Default 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