Pie - data value & label

[Anne Zarzycki]

I am using Excel 97. Is there anyway on a pie chart to
display the label and VALUE rather than label and PERCENT.

 

[Debra Dalgleish]

You can use a formula to create the label that you want. For example,
with categories in cells A1:A10 and values in B1:B10 --

1. Enter the following formula in cell C1:
=A1 & CHAR(10) & B1
2. Copy this formula down to C10 (ignore the white box that appears
in the formula)
3. Select cells B1:B10, and click the Chart Wizard button
4. Select the Pie chart, and one of the pie chart subtypes
5. In step 2 of the Wizard, on the Series tab, click in the
Category Labels box, then select cells C1:C10
6. In step 3, on the Labels tab, select 'Show label'
7. Click Finish

 

[Anne Zarzycki]

Worked great! Thanks!!!!!

-----Original Message-----
You can use a formula to create the label that you want. For example,
with categories in cells A1:A10 and values in B1:B10 --

1. Enter the following formula in cell C1:
=A1 & CHAR(10) & B1
2. Copy this formula down to C10 (ignore the white box that appears
in the formula)
3. Select cells B1:B10, and click the Chart Wizard button
4. Select the Pie chart, and one of the pie chart subtypes
5. In step 2 of the Wizard, on the Series tab, click in the
Category Labels box, then select cells C1:C10
6. In step 3, on the Labels tab, select 'Show label'
7. Click Finish


PERCENT.


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

.