Percent Value in Pie Chart Legend

  • Thread starter Thread starter JST
  • Start date Start date
J

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,
 
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
 
Back
Top