Total of Stacked Column Chart

[Karen]

Using 2003
I have a stacked column chart with 10 different stacks/series of data. I
want to show the total of all the stacks at the top of each column. What I do
now is add it up manually and insert the total into a text box. Is there an
easier more automated way to do this?
Thanks, Karen

 

[Andy Pope]

Hi,

Add a series, plotting as line, which is is the total of each stack.
Display data labels in the above position and format the line as none
with no markers.

Or use a column on the secondary axis, again removing formatting and
applying data label
http://www.andypope.info/charts/StackColTotal.htm

Cheers
Andy