View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
bflorox bflorox is offline
external usenet poster
 
Posts: 13
Default date and time on line chart

I have a date and time stamp automatically generated (with a macro) when a
value is entered into the neighboring cell. The actual time between entries
is not important so I want a line chart, not XY. I can't get the line chart
to recognize the time component of date/time stamp. All entries for one day
end up piled on top of one another. How do I get XL to plot the time
component as well?

Thanks.