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.

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.