View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
Elizabeth Elizabeth is offline
external usenet poster
 
Posts: 71
Default Excel 2003- Charts- date and time format on x-axis of XY chart

Hello,

I am trying to plot an XY graph with x-axis data in date and time format but
Excel keeps counting the x-axis data as "data labels". It is in the format
mm/dd/yy HH:mm
ex) 10/28/06 17:00

Instead, Excel appears to be turning my XY plot into a line plot (for
example, the first date is assigned an x-value of 1, the second value
assigned an x-value of 2 and so on so that each date/time x-value is evenly
spaced).

I would like to find a way to plot this data so that it is spaced relative
to date and time.