how to create a clustered, 100% stacked combination chart

[Guest]

I want to create a chart with 2 100% stacked columns to compare % of 2
different years.

 

[Andy Pope]

Hi,

Maybe you can use the information here but using 100% stacked columns.
http://peltiertech.com/Excel/ChartsHowTo/ClusterStack.html

Cheers
Andy