View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
UncaJJ UncaJJ is offline
external usenet poster
 
Posts: 6
Default X axis collapsing to date on hourly data

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