Simple table combining bar with stacked bar chart

[cwb124]

Hey folks, I've looked at some tutorials but didn't find anything specific to what I am trying to do. I think i was close but I'm missing something and hoping someone can put me over the top here.

Essentially I have 5 rows that represent 2018-2022. I have 3 columns that represent Product A opex, Prodcut B opex, product B capex.

I need a chart that has a bar showing Product A opex, and then a stacked bar chart showing combined opex and capex for product B for all 5 years. I can't seem to figure it out. Any help would be appreciated. Thank you!

[CAntosh]

Welcome to the forum!

I don't know of a clean way to do this, but you can the requested look by creating a couple filler columns, then creating a chart with a secondary axis. The idea is that you put B opex and B capex on the secondary axis as a stacked chart, which will place them directly over top of the clustered bar charts showing A opex and the two empty filler columns. The filler columns provide the space needed so that you can narrow the stacked chart so it visually sits alongside the A opex bar, even though it technically is squatting on top of the two ghost filler columns. Hopefully that makes sense? Take a look at the attachment to see if it's capturing what you're after:

stack-cluster bar chart combo.PNG