LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 1
Default Line Graphs with X-Axis Representing Hours

Here's the data I want to plot with multiple lines, one for A, B and C, which
are quantities of things. The start time actually represents the start of an
hourly window when these things accumulate. So one would read this as
"Between 7:00 and 8:00, 944 things accumulated, 786 of them were B things and
158 were C things.

Start A B C
07:00 944 786 158
08:00 24,445 21,802 2,643
09:00 61,540 56,505 5,035
10:00 62,938 57,748 5,190
11:00 59,737 54,864 4,873
12:00 42,903 39,228 3,675
13:00 48,001 43,873 4,128
14:00 53,206 48,839 4,367
15:00 49,850 45,613 4,237
16:00 30,668 28,066 2,602
17:00 8,912 7,858 1,054
18:00 2,445 2,113 332
19:00 201 168 33

I created a line chart with 3 series, the A, B and C ranges. The x-axis
labels are the start times. When plotted, with the data table displayed
below the graph, in each column of the table is:
Start Time
A value
B value
C value

which is fine but the time is just the start time of the window, not the
actual time when those values occurred. To make it somewhat more readable, I
took Jon's advice and change the start time to the duration of the window.
When that's plotted, it looks like the first quantity is collected at the
middle of the time window, like 7:30. That's obviously also not true.

Any advice on how to make this more readable?

Thanks.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Y Axis and line graphs Gupta A. Charts and Charting in Excel 0 January 2nd 07 06:16 AM
Producing line and bar graphs on same axis smurray444 Charts and Charting in Excel 1 November 21st 05 05:20 PM
Increasing X-axis Offset for graphs cutting x-axis Hari Prasadh Charts and Charting in Excel 2 August 23rd 05 09:23 AM
How do I create a line graphs with months labelled in the X-axis? Aisha Khan Charts and Charting in Excel 2 February 3rd 05 10:22 PM
Creating a chart representing hours used joemc911 Charts and Charting in Excel 1 February 2nd 05 02:03 PM


All times are GMT +1. The time now is 02:10 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"