I created action filter on my sheet(sheet9), that will take user id and apply it to another sheet(sheet 10), my problem is that i have to select one by one or do a mouse drag select, in the attached workbook you will that the sample size is really small, in my actual data there is like 500+ user id in one bar, i want to be able to select one bar which will send all the user id's in it to the action filter.

I hope i'm explaining this as clear as i can, i'm happy to explain further if anyone is interested, thank you.

I want to be able to click on pie chart _slice_ in sheet 9(question), that will filter action _2_ user ids to sheet 10 (nationality), im so sorry im aware im not good with explaining, but im really new at this.