Total of Stacked Column Chart

  • Thread starter Thread starter Karen
  • Start date Start date
K

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
 
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
 
You must log in or register to reply here.

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

Stacked Columns with different series in each column 0
Problem with stacked column chart 5
Combo Stacked column/column/line 1
Stacked Column Chart - Total that isn't the sum of series 1
Stacked Column Chart 2
Clustered-Stacked-Column Combo Chart With Lines 2
Totals in Stacked Column? 1
Show total in a Stacked Chart 1

Back
Top