Archive of Mr Excel Message Board

Check out Bill's new book on Charts and Graphs for Microsoft Office Excel 2007

Back to Charting for Excel archive index
Back to archive home

Charts anyone?

Posted by Terri on February 08, 2002 3:11 PM

I am trying to create a chart for some benefits and and I would like to display them as a percentage of a whole(total cost) and I don't know how to get it to do that...is there a formula I should be using or should all the data be on a sheet already totaled? I am not very experienced with charts or graphs, any help would be appreciated!

Re: Charts anyone?

Posted by Nib on February 08, 2002 7:20 PM

Terri,
Your data SHOULD be on the sheet (already totalled) so that it can be included in your chart/graph. To display the benefits as a percentage: value of benefit *100/sum of all benefits. If you replicate the formula down the column don't forget to use absolute references, eg. if your sum of all benefits is in cell A10 your formula becomes, value of benefit *100/$A$10.
Highlight your data,insert chart of your choice and follow steps.
HTH

Re: Charts anyone?

Posted by Mark W. on February 09, 2002 1:47 PM

You could create a pie chart. Suppose A1:A3
contains your benefits...

{"Free ice cream",500
;"Unlimited sick time",2500
;"Concierge service",800}

Select cells A1:A3 and click the Chart Wizard.
Choose the Pie chart type at Step 1 of 4. At
Step 3of 4 choose the "Show percent" Data label
radio button, and press [ Finish ].

This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.