MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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 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!

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

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.

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 ].