Stacked and clustered combo chart

[DrVanNostrand]

I am trying to create a stacked and clustered combo chart in Excel. For each column, I want to show 3 'bits' 'stacked' on top of each other so it's clear by how much each bit exceeds the other two bits. They won't really be stacked in a technical sense as each bit is a total and so only its 'excess' amount would be visible.

I am able to do this if it's only two bits: see image

But once I add a third it becomes messy. I have tried adding a secondary axis: see image

Here's the Excel file.

Thanks!

 

[Sergius]

Hello! Is this what you want?