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!