RANGE HELP. Horizontal Bar Graph - 5 categories, 5 Sub categories, data is RANGE

Hello all,

Not very good with graphs so I appreciate this...

All tabs represent a type of resin from biologics companies. All data needed is summarized in the "Combined" tab

The Y axis will have 5 categories/series: Chemistry that follows the tabs (Affinity, AEX, CEX, Mixed Mode, HIC) - I only have it in column B for Affinity right now.
Within that will be 5 sub categories/series of the companies (Sartorius, Cytiva, EMD, Bio-Rad, Thermo Fisher). Each one being an individual color

So 5 sections with 5 horizontal lines in it.

The x-axis will be "Particle size" and based off of the data in column C - the size. This is where I'm lost. I do not want each and every type plotted but a range based on the values. For example, Cytivia Affinity will be 33-100 but the X-axis can be 20-200.
I put a small example in columns e-k in the combined tab.

Could I just put the low and high? Yes I could but I want to keep adding to this, so dynamic if possible.

All of the information contained within this is from websites. No confidential company info.

Thank you so much in advance!