Excel 2016 - Stacked Bar Chart with Total labels

XLUser999

New Member
Joined
Sep 23, 2016
Messages
3
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.
 

Some videos you may like

Excel Facts

Control Word Wrap
Press Alt+Enter to move to a new row in a cell. Lets you control where the words wrap.

XLUser999

New Member
Joined
Sep 23, 2016
Messages
3
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

New Member
Joined
Aug 22, 2016
Messages
20
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

New Member
Joined
Aug 22, 2016
Messages
20

ADVERTISEMENT

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

XLUser999

New Member
Joined
Sep 23, 2016
Messages
3
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,122,893
Messages
5,598,712
Members
414,254
Latest member
MarieCo

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top