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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 | |
|
|
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 |