Create a Clustered Stacked Column Pivot Chart in Excel

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 RUclips: ruclips.net/user/contextu...

[@Andrea_Cholico]

Thank you!! Very clear and easy to follow!! This helped me a lot!

[@contextures]

You're welcome, Andrea, and thanks for your comment!

[@ArthurSantos-ss6cw]

This helped me a lot. Thanks!

[@contextures]

You're welcome, Arthur, and thanks for letting me know that the video helped you!

[@OmarGarcia-ks8rh]

Very Good, thanks

[@contextures]

You're welcome, Omar, and thanks for your comment!