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
aspelker wrote:
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
--
Andy Pope, Microsoft MVP - Excel
http://www.andypope.info