Excel 2016 - Stacked Bar Chart with Total labels

[XLUser999]

Hi

This is the essence of what I want to achieve: a stacked bar chart showing the row grand totals:

Label 1 XXYYYYYYZ 9
Label 2 YYYYYZZZZ 9
Label 3 XXXXXYYYZZZZ 12

x-axis is e.g. 1 - 12.

(X, Y, Z = chart colours).

Needs to be standard Excel (no macros).

Thanks.

 

[KasperKL]

Hi there,

I believe this guide shows you exactly how to achieve that:
https://www.extendoffice.com/documents/excel/1334-excel-add-total-to-stacked-bar-chart.html

 

[XLUser999]

Hi KasperKL

Thanks. Yes I can produce a Stacked Column chart with totals - it's the Stacked Bar chart I can't crack!

Regards.

 

[KasperKL]

Your data should look something like this:

header header header
header value value value
header value value value
header value value value

Then select it all, go to the 'Insert' tab on the ribbon.

Click the little button in the mid of the ribbon called 'Insert Column or Bar chart' and choose 'Stacked Bar' (under the category: 2-D Bar).

Are you having trouble with some of the above?

 

[KasperKL]

The method in the article should be the same for a stacked bar as a stacked column AFAIK

 

[XLUser999]

Hi KasperKL

Thanks for your replies. No matter what I do I can't get the Stacked Bar to behave in the same manner as the Stacked Column (I can get the Stacked Column/Line combo to work ok but not the Stacked Bar/Line combo ... unfortunately it's the latter that I need.)

Regards.

 

[trymzet]

Follow this tutorial for your bar chart: https://www.exceltactics.com/how-to-add-totals-to-stacked-charts-for-readability/

It's a bit messy if you have to create a few of these every now and then, so in such case you may want to write some VBA to create them (or use some data viz software).