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
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"cardan" wrote in message
oups.com...
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.