Thread: Building a Dynamic Chart using ranges in rs1 method

Hi,
Hoping to get some help building a dynamic chart using the rs1 method but having trouble setting up the data. The goal is to allow users to select "facilities" and view a chart for each facility based on vendor spend, product count, quarterly view of the same spend/count information.

On Sheet 1, I am having trouble figuring out how to get all the Product info into the Chart Basis when a Facility is chosen. Example, when F1 is chosen, the chart should display: Product, Vendor, Period, and count for each vendor. Sample data file attached. How do I index the other Vendor/Product data to show up for each Facility chosen??

Looking forward to any help!

Thank you!