how to show both value and percent in pie charts?

[Guest]

I am using excel 2000 version. In customizing my pie charts, i can only show
the data label as a value or as percentage.How can i show both value and
percent in pie charts? tnx

 

[Tushar Mehta]

Roll your own data label with the following.

Suppose your data are in A starting with A1. Name the data range
(Insert | Name > Define...) DataRng.

In B1, enter the formula =A1&CHAR(13)&TEXT(A1/SUM(DataRng),"##0.00%")
Copy B1 as far down col. B as there are data in col. A.

Plot col. A. Use XY Chartlabeler (www.appspro.com) or Chart Tools
(www.j-walk.com) to label the pie with the series in col. B.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions