Isolate group of names from Drop down list
 

Hello. I have a chart based on all of our companies site locations, that has
three drop downs to isolate the data on the chart. Several of our sites are
owned by the same company. Is there a way to populate a chart or reference a
data sheet for all of the sites that are owned by that company(Their name is
in the title/drop down). I.e. I want that every time I select "Xxxx Smith" I
can make a chart that has all of the "smith's" data.

Sorry if this is confusing...I know I am.