ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Show total in a Stacked Chart (https://www.excelbanter.com/charts-charting-excel/142151-show-total-stacked-chart.html)

Bryan Potter

Show total in a Stacked Chart
 
Is it possible to display a total value for each stacked column on a stacked
chart. I'm able to show the values for the various series of each column,
but can't seem to find a way to show a total.

Thanks,

B


Andy Pope

Show total in a Stacked Chart
 
Hi,

Simplest way is to add an additional data series to the chart, which is
the sum of the stacked data series. And plot this as a line chart. You
can format the line series to have no line color or markers. The data
labels will display the total value and can have the alignment property
set to Above.

Cheers
Andy

Bryan Potter wrote:
Is it possible to display a total value for each stacked column on a stacked
chart. I'm able to show the values for the various series of each column,
but can't seem to find a way to show a total.

Thanks,

B



All times are GMT +1. The time now is 02:56 PM.

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