Stacked bar chart with grouped X-axis

Good morning TW,

Looking to reproduce an excel chart in a TDP report. Below are screen shots of the raw data and the chart. Some manual prep work went in to the presentation of the data, but for the most part, this can be reproduced in query form. I've got several categories that need this visualization and was hoping to leverage the grouping feature in a report to automate. Any tips or suggestions would be greatly appreciated!

Chart.jpeg

[View:/cfs-file/__key/communityserver-discussions-components-files/36/Sheet1.xlsx:320:240]