stacked column chart

  • Thread starter Thread starter Conditional join
  • Start date Start date
C

Conditional join

I have a stacked column chart and I added data labels showing values. I want
the chart to graph the value with the column bars, but I would like to see
the percentages with those bars instead of the value. For example, the total
for the column bar is 200 with the break down as such: Group = 50,
Individual = 25 and Enterprise 125. I want the stack bar to show a total of
200, but instead of the labels showing the value of 50, 25 and 125 for Group,
Individual and Enterprise, I want the labels to show 25% for Group (50/200),
12.5% (25/200) for Individual and 62.5% (125/200) for Enterprise. Is this
possible? I don't want to switch to the 100% stacked column chart as that
put everything at 100%. I want to show the full value and then the
percentages within those sections.
 
Very helpful. Implicit in the "Can I?" was "How do I?"

Compute your percentages, or construct any custom labels in a worksheet
range, then use one of these free utilities to apply the text in this range
to the data labels in the chart:

Rob Bovey's Chart Labeler, http://appspro.com/Utilities/ChartLabeler.htm
John Walkenbach's Chart Tools,
http://www.j-walk.com/ss/excel/files/charttools.htm

You can do it manually, but after about three labels it becomes very
tedious.

- Jon
 
Hi Driller,
Could you please tell me how to do it? I also have the same problem...
Thanks!!

Louisa
 
Compute your percentages, or construct any custom labels in a worksheet
range, then use one of these free utilities to apply the text in this range
to the data labels in the chart:

Rob Bovey's Chart Labeler, http://appspro.com/Utilities/ChartLabeler.htm
John Walkenbach's Chart Tools,
http://www.j-walk.com/ss/excel/files/charttools.htm

You can change the labels manually, but after about three labels it becomes
very tedious.

- Jon
-------
Jon Peltier, Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/>
Advanced Excel Conference - Training in Charting and Programming
http://peltiertech.com/Training/2009-06-ACNJ/AdvExcelConf200906ACNJ.html
_______
 
Back
Top