Excel doesn't have a Cluster Stack chart type, but you can make a pivot chart with stacked columns that are grouped into "clusters".
Watch this video to see how to set up a pivot table, based on an Excel table with quarterly sales data.
Next, create a pivot chart, with region and year in the horizontal axis, and a stacked column for each year.
Get the sample file from my Contextures website:
www.contextures.com/excelclus...
Or use this short link: myctx.link/pivotstack
Video Timeline
0:18 Excel Table
0:41 Make a Pivot Table
2:33 Add a Pivot Chart
3:04 Format the Chart
Instructor: Debra Dalgleish, Contextures Inc.
Get Debra's weekly Excel tips: www.contextures.com/signup01
More Excel Tips and Tutorials: www.contextures.com/tiptech.html
Subscribe to Contextures KZread: kzread.info...