Creating a table of values in a pie chart legend

[simmo86]

I have a pie chart showing percrentages on it, and then I have a legend showing what wach thing is, I really want the legend to have not only the name of it but the value of it.

Is this possible?

Thanks in advance

Alex

[Andy Pope]

Yes if you calculate the percentages using formula and combine that with the category name you can use the resulting cells as the labels

Assuming labels in A2:A5. data in B2:B5.
Create new labels in C2:C5 with this formula in C2 copied down.

=A2 & " ("&TEXT(B2/SUM($B$2:$B$5),"0.0%)")

[simmo86]

Hi Andy, thanks that is very usefull. The only issue is;

I am showing someones investments in a pie chart, so I want to have the percentage of their investments on the pie chart itself, and in the legend, I want the name of the fund and the value of the fund next to it, also with a total of all their funds at the bottom of the legend. Is that possible?

Thanks in advance

Alex

[Andy Pope]

Probably.

I have shown you how the extra information can be made part of the legend text. All you need to do is change the formula. If you want the actual value just reference the cell and don't do the percentage calculation