Morning All,

I hope this is in the right place on the forum...

I have a MSQuery generated table on Sheet1
and a Stacked Column Chart on Sheet2

I want to filter the data on the table but can only do so from the Table on Sheet1.

Is there any way in which i can create something similar to a Data Validation list on Sheet2 changing the filter in Sheet1?

Or another way which i haven't thought of?

Thanks
Ross