Create interactive drop down (multiple) to display data as Chart and table

[voicetec]

Hi

Hope you can help - This is what I want to do.

Problem - I want to have 4 different filters that are dependent on each other - so that when selection is made the data will be displayed in a summary table, Chart and the raw data below the chart. I also want the default selection be be [ALL] - so if no selection is made the table will just show ALL data - with no chart or raw data

I have attached dummy data.

So Sheet 1 is where my filters will be and also display data on table, chart and raw data
Sheet 2 - will be my data dump - this will have raw data