X axis collapsing to date on hourly data
Don't use a line chart. Use XY, & include the lines there if you want them.
--
David Biddulph
"UncaJJ" wrote in message
ups.com...
Hello,
I have a spreadsheet I am trying to chart that has values by date and
time, IE
Date-Time, Value
9/17/07 20:00, 1
9/17/07 21:00, 2
9/17/07 22:00, 4
9/17/07 23:00, 1
9/18/07 00:00, 2
9/18/07 01:00, 1
9/18/07 02:00, 0
When I highlight all of the above and select "Insert Chart" and choose
line chart, it creates the chart as if it had the following
information:
Date-Time, Value
9/17/07, 8
9/18/07, 3
It also looks more like a bar chart then a line chart. Anyone have an
idea on why this would happen and how to fix it?
-Jason
|