Hi,

Does this work around help?
http://www.andypope.info/charts/StackColTotal.htm

Cheers
Andy

Angela wrote:
I need help. I have a chart with multiple columns and three rows. Each row
has a total. I would like to do a stacked column chart shoeing the each rows
value and the totals without the totals effecting the chart. When I try and
do it now, the total throws off the chart?

--

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