Adding Percentages to a Stacked Chart

  • Thread starter Thread starter cardan
  • Start date Start date
C

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.
 
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
 

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

Stacked Bar Chart 1
stacked column chart 4
Excel How to create a stacked bar graph 0
adding percentages to stacked bar charts 1
Help figuring out chart design 2
Stacked bar chart and Line 3
Percentages AND Value lables on Stacked Columns 1
Replace Chart Values with Second Set of Values 1

Back
Top