Help with clustered stacked horizontal bar chart

[slade8200]

Hi, I'm trying to create this chart. Please see below:

bar chart.png

The data:
chart data.png

The top set of data is what made the chart (minus the red rectangles which I added in paint). The max and avg columns aren't used in the graph.

I want to use the 2nd set of data (the lower set), to put another "series" of data in at each Y-axis marker (60, 55, 50, etc.); sort of what I drew with the red rectangles.

Is this even possible?

Thank you.

[MrShorty]

Here's my go to tutorial for clustered and stacked column and bar charts: https://peltiertech.com/clustered-st...mn-bar-charts/
Note that the chart itself is a regular stacked column/bar chart, and most of the effort to build the chart goes into arranging the data in the spreadsheet.