Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to plot hourly data | Charts and Charting in Excel | |||
Timeline based on hourly data | Charts and Charting in Excel | |||
Plot Hourly Data | Charts and Charting in Excel | |||
How to convert half hourly data into hourly | Excel Discussion (Misc queries) | |||
How do I sample hourly data one time per day | New Users to Excel |