Total on Stacked Column Chart

G

Guest

I was wondering if there is a way to put the total on top of a stacked column
chart. I am currently doing it using a text box, but the problem is that
when the values in the chart change, the total does not move with the top of
the coumn. Is there a way to put the total for a stacked column chart where
it will dynamically change and move with the column. Thanks!
 
G

Guest

I think you might need to have an extra column being series 1 + series 2 etc.
Then add this to the chart and format it as a line chart. format the data
point to none & point format to none and desplay data labels.
--
John
MOS Master Instructor
Please reply & rate any replies you get

Ice Hockey rules (especially the Wightlink Raiders)
 

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

Pivot Chart Trendline? 0
Column with Stacked Column 1
Stacked Bar Chart 1
how to total 3 series in a column chart 4
Clustered and Stacked Column Chart 2
A combination chart of column with a stacked column 1
Column Chart 2
Stacked column-chart Excel 2007 1

Top