How do I add Cumulative values to Stacked Bar chart?

G

Guest

I have a stacked bar chart in which i want to show the value label of each
section and show the cumlative value. So if there is section A,B,C and A= 1,
B= 2, C = 3 I want each section to have those labels but i also want labels
that say 1, 3, 6 for the cumulative values. Is there anyway to do this?

Thanks
 
A

Andy Pope

Hi,

Use a helper column to build the required text for each data label.

So if you data values are in B2:B4 then put the following in C2 and copy
down.

="Value = " & B2 & CHAR(10) &"CumValue=" & SUM($B$2:B2)

Then use either of these free addin to make the linking of cells and
data labels easier.

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

Cheers
Andy
 

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

Cumulative Data Labels on Stacked Bar/Column Chart 1
Total number display in stacked charts 1
stacked column chart 4
Stacked Bar Chart 1
Stacked bars with textlegends in each stacked bar 7
Stacked Line Chart 3
Excel 07 - Stacked Chart Labels on Negative Values 1
Stacked Bar chart - percentage share of a bar info 1

Top