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!

Hi,

Have a look at this explanation
http://www.andypope.info/charts/StackColTotal.htm

Cheers
Andy

Scott wrote:
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!

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

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)


"Scott" wrote:

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!