I would like to display the % of a pie chart on the legend

E

erock

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?
 
A

Andy Pope

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Legend and text entry 1
edit chart legend spacing 11
legend on the chart 1
How do I put text in a chart legend box? 1
How to display both $ in pie chart and % in legend 1
Excel 2007. Is it possible to format Legend Key? 3
Problem with pie chart 1
change the text in the legend of a chart w/o changing pivot text 2

Top