View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Jon Peltier Jon Peltier is offline
external usenet poster
 
Posts: 6,582
Default date and time on line chart

See my reply in the other thread you started.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"bflorox" wrote in message
...
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.