Hi,
Yes but you will need to build the text you want to display in a cell,
including a formula to calculate percentage.
For a data set in range A1:B5,
B1:=Slices
A2: =a B2: =1
A3: =b B3: =2
A4: =c B4: =3
A5: =d B5: =4
Put the following formula in C2 and copy down.
=TEXT(B2/SUM($B$2:$B$5),"0.0%") & " - " & A2
Create the pie on the range A1:B5 and then via the Source Data dialog
change the category labels range to C2:C5.
Cheers
Andy
erock wrote:
i can put the % next to the text by the graph, but I was hoping to put it on
the legend next to the color followed by the description. Is this possible?
--
Andy Pope, Microsoft MVP - Excel
http://www.andypope.info