A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Charts and Charting
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Which type of chart would you suggest to use?



 
 
Thread Tools Display Modes
  #1  
Old February 16th, 2006, 05:45 AM posted to microsoft.public.excel.charting
external usenet poster
 
Posts: n/a
Default Which type of chart would you suggest to use?

Hi all,
I have a group of users with cost utilization data for each year from 2001
to 2003 and also network data side by side. I'd like to use Excel chart to
display the trends.
The following is my sample data, Can anyone give me some idea what type of
chart I should use? or if you have any sample chart that I can look at?
Thanks for all your help in advance!!! Jenny
UserID 2001 2001Net 2002 2002Net 2003 2003Net
A 14.09 13 15.64 14.5 16.85 15.4
B 6.56 13 9.78 14.5 9.92 15.4
C 5 13 7 14.5 8 15.4
D 3.25 13 3.04 14.5 3.15 15.4
E 8.9 13 4.8 14.5 7.8 15.4
F 6.26 13 6.07 14.5 6.38 15.4
G 11.28 13 13.09 14.5 14.32 15.4

Ads
  #2  
Old February 17th, 2006, 05:48 AM posted to microsoft.public.excel.charting
external usenet poster
 
Posts: n/a
Default Which type of chart would you suggest to use?

I would make a combination chart with the utilization data as columns and
the net data as lines. To do this, first delete UserID from the top left
cell (to help Excel parse the data range). Select the data and make a
clustered column chart. Then one by one select a Net series, and on the
Chart menu, use Chart Type to change the series to a line type. (You can
probably use the F4 shortcut key to repeat the latest action, to change the
second and third series to lines.)

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

"Jenny" wrote in message
...
Hi all,
I have a group of users with cost utilization data for each year from
2001
to 2003 and also network data side by side. I'd like to use Excel chart to
display the trends.
The following is my sample data, Can anyone give me some idea what type of
chart I should use? or if you have any sample chart that I can look at?
Thanks for all your help in advance!!! Jenny
UserID 2001 2001Net 2002 2002Net 2003 2003Net
A 14.09 13 15.64 14.5 16.85 15.4
B 6.56 13 9.78 14.5 9.92 15.4
C 5 13 7 14.5 8 15.4
D 3.25 13 3.04 14.5 3.15 15.4
E 8.9 13 4.8 14.5 7.8 15.4
F 6.26 13 6.07 14.5 6.38 15.4
G 11.28 13 13.09 14.5 14.32 15.4



 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
pasting chart shows chart area, not the chart Pirjo Powerpoint 3 October 13th, 2005 04:31 AM
Pivot Chart - default chart type Rav99 General Discussion 4 September 6th, 2005 01:20 AM
Chart Type Kerning Issue DougB Powerpoint 3 April 23rd, 2005 06:47 PM
Chart Type toolbutton instead of Chart Wizard Sam Charts and Charting 2 April 18th, 2005 05:30 PM
Keep Pivot Table custom chart type Jeff M Charts and Charting 3 April 8th, 2005 08:58 PM


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


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright 2004-2017 OfficeFrustration.
The comments are property of their posters.