Adding Percentages to a Stacked Chart

[cardan]

Hello all,

I have a question, which I thought was simple. I have a bar graph
chart where the values are stacked on top of one another. (series is
rows). I have place the values of each bar within the bars but would
also like to show the percentages along side (or within) the bars. Is
this possilbe? I can add another bar and show the percentages but this
would not be very presentable. Any suggestions? Thank you in advance.

 

[Jon Peltier]

In the worksheet, set up custom labels that show what you want, with value
and percentage together in the cell.

For example, if the data is in B2:B5, the label for B2 goes into C2, and
uses a formula like this:

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

which will give a label like

12.5 (18%)

Fill this formula down to C5.

Now use one of these free labeling tools to apply the labels in C2:C5 to the
data points:

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

- Jon