Show Value & Percent Data Label

  • Thread starter Thread starter Atchleykl
  • Start date Start date
A

Atchleykl

I'm trying to do a pie chart that show both the value and
the percentage but have had no luck. Does anyone have a
trick on how to get both to show up at the same time?
Thanks. Kathy
 
Kathy -

You need to make labels in the sheet, then apply them to the chart.

If your chart data is in C2:C5, select D2:D5 and type this formula:

=C2&" ("&TEXT(C2/SUM(C$2:C$5),"0.0%")&")"

and don't press Enter. Instead hold down Ctrl while pressing Enter.
Holding Ctrl puts the formula into the entire selected range. The
formula gives you the value and the percentage in 0.0% format.

Now get ahold of one of these free chart labelers:

Rob Bovey's Chart Labeler, http://appspro.com
John Walkenbach's Chart Tools, http://j-walk.com

These let you choose the chart and series, then indicate which worksheet
range holds the labels. It does the rest.

- Jon
 
Kathy,

If you have Windows 2000 here is an easy way to shoow the value an
percentages on your chart:

1. click on a slice in your pie chart
2. choose "format data labels"
3. choose "data lables" tab
4. check the "value" and "percentage" boxes
5. click "ok
 
Unfortunately, you can only select one radio button at a time. I'm sure
Kathy tried choosing multiple ones before posting her question.

- Jon
 
Back
Top