ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Chart totals (https://www.excelbanter.com/charts-charting-excel/92703-chart-totals.html)

Angela

Chart totals
 
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

Chart totals
 
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


All times are GMT +1. The time now is 08:39 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com