date and time on line chart

  • Thread starter Thread starter bflorox
  • Start date Start date
B

bflorox

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.
 
Back
Top