This may help
http://www.andypope.info/charts/StackColTotal.htm

Cheers
Andy

keet16 wrote:
I am trying to create a stack bar chart that will only show the total of all
the series.

How can this be done. I have searched, but can not find anything that will
allow me to setup the total of a number of chart series.

--

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