Excel Pie Charts

Posted by Cindy on March 06, 2001 5:59 AM

I would like to include value, percent, and labels in a pie chart.
Is there a way to include all three and how would I do it?

Thanks
Cindy

Posted by Mark W. on March 06, 2001 7:54 AM

Cindy, yes you can. Let's assume that cells
A1:B4 contain:

{"Fruit","Amount"
;"Apples",10
;"Bananas",15
;"Grapes",25}

First, you'll need to apply a data label by
choosing the Show value radio button on the
Chart Options Data Labels dialog. Next, in
cell C2, enter the formula,
=A2&CHAR(10)&B2&CHAR(10)&TEXT(B2/SUM(B:B),"0%"),
and copy down to cell C4. Now, select each
of the existing data labels in turn, and click
on the formula bar

Posted by Mark W. on March 06, 2001 7:56 AM

...type an equal sign (=), click on the correspond-
ing value in column C and press enter.