Make a Clustered Stacked Chart in Excel

Excel doesn't have a Clustered Stacked chart type, but you can build one yourself, with a cluster for each region, and a stack for each year.

This short video shows how to set up your Excel data, with blank rows to space the data, and data on different rows.

Then, build the chart, and make a couple of quick formatting changes, to end up with a clustered stacked chart

To get the Excel workbook for this video, go to the Create Excel Cluster Stack Charts page on my website:

https://www.contextures.com/Excel-Addins-Charts-Cluster.html

Video Timeline
00:00 Introduction
00:19 Cluster Stack Chart
00:40 Data Layout
01:52 Make the Chart
02:32 Format Chart
02:58 Change Colours

Instructor: Debra Dalgleish, Contextures Inc.
Get Debra's weekly Excel tips: http://www.contextures.com/signup01
More Excel Tips and Tutorials: http://www.contextures.com/tiptech.html
Subscribe to Contextures YouTube: https://www.youtube.com/user/contextures?sub_confirmation=1
#ContexturesExcelTips

Make a Clustered Stacked Chart in ExcelExcel chartExcel cluster stack chart