Posted to microsoft.public.excel.charting
|
|
X axis collapsing to date on hourly data
Format Axis/ scale tab.
--
David Biddulph
"UncaJJ" wrote in message
ups.com...
Well, that does look better, but it shows 2 extra days on the graph.
http://img.photobucket.com/albums/v7...ywithlines.jpg
The data set starts with 9/24/07 00:00:00 and ends with 9/30/07
23:00:00 with every hour in between, and there's no reason I see that
it should have 9/23 and 10/2 on the graph.
On Sep 24, 2:56 pm, "David Biddulph" <groups [at] biddulph.org.uk
wrote:
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
|