Percent Value in Pie Chart Legend

[JST]

I have a pie chart that is dynamically recieving data from a SQL dB. I
would like to have the legend of this pie chart show both the value,
and the percent value for the data. Is this possible?
Thank you,

 

[Jon Peltier]

The legend? Or the data label?

In either case, make a formula that shows these items. For instance, if
your data is in B1 to B5, put this formula into A1:

=B1 & " (" & TEXT(B1/SUM($B$1:$B$5),"0.0%") & ")"

This gives you the value plus the percent in parentheses after it.

To get these into the legend, just select A1:B5 before creating the
chart. To get them into the data labels, use one of these free addins to
apply the labels in A1:A5 to the points:

Rob Bovey's Chart Labeler, http://appspro.com
John Walkenbach's Chart Tools, http://j-walk.com

- Jon