Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Charting / April 2008

Tip: Looking for answers? Try searching our database.

Line Graphs with X-Axis Representing Hours

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
drjeckl - 29 Apr 2008 21:05 GMT
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.
Jon Peltier - 29 Apr 2008 22:29 GMT
Make an XY chart, not a line chart. That might be enough to clarify the
problem.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______

> Here's the data I want to plot with multiple lines, one for A, B and C,
> which
[quoted text clipped - 38 lines]
>
> Thanks.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.