Clustered and Stacked Column and Bar Charts Excel 2016

This was an incredibly annoying issue I had since I could not figure out how to have multiple stacked columns for different categories on a chart. What worked for me was a combination of these two guides:

1. http://www.exceldashboardtemplates.com/how-to-easily-create-a-stacked-clustered-column-chart-in-excel/ This has good ideas on how to configure the table
2. http://excelhelphq.com/tutorial-clustered-stacked-column-bar-charts-free/ This actually shows you how to layout the data. Basically, you end up having multiple rows for the same series to have individual columns