Need to show percentage reduction on bar chart

  • Thread starter Thread starter Salman
  • Start date Start date
S

Salman

Hi.

I have a chart with two stacked columns on it. Say the
values on the left stack are 200, 100, 80 and on the right
stack 120, 40, 20. I want to display the totals on top of
each stack ie 380 and 180. Secondly to the right of the
right hand stack I want to show the percent reduction in
each component. So 40%, etc.

Is there a way to do these two tasks?

Thanks.
 
Put the totals (380, 180) into the worksheet, and add these as a new
series. The series will be added as another stack, but right click on
it, choose Chart Type, and select a line type to change it. The points
are aligned with the top of the stacks. Double click the new line
series, on the patterns tab select None for markers and line, and on the
Data Labels tab, select Show Values, then press Okay. Double click the
labels, and on the Alignment tab, choose Above for Position.

Select the first series, then select the last point (120). Press Ctrl-1
(numeral one) to format it, and on the Data Labels tab, select either
Show Values or Show Labels. Single click twice on the data label, until
it's surrounded by a gray rectangle. Type whatever value you want into
the formula bar; or press the Equals key and select a cell, if the value
is contained in a cell, and the label will be linked to the cell. Press
Enter, then drag the label to its final position.

Rob Bovey's Chart Labeler (http://appspro.com) and John Walkenbach's
Chart Tools (http://j-walk.com) are free addins that automate the
process of adding labels from the worksheet to a chart. Rob's has the
added functionality of allowing you to position the labels with arrow
buttons.

- Jon
 
Back
Top