date and time on line chart

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Space at end of multi page list to accommodate new entries 1
Creating a dynamic chart range where the range to be graphed depends on the contents of a cell 0
Date and Time Picker 6.0 0
Autofill Date in Word 15.33 for Mac 0
Move Chart with Text 0
Line Chart - Problems with labeling X-Axis 3
Style Gallery View 3
How do I create a scrolling line chart? 0

Top