alternate chart via check box

[Afarag]

Dears,

please i ask for help that i have some data from pivot table which i need to show it in charts, but there's are more factors that i can show the chart for it's factor via check box

Thanks a lot,

 

[Afarag]

and choose from the leaders via data validation list instead of the pivot slicer, as when i select the leader give me his data only to apply it in the chart

Thanks

 

[malleshera]

Hi Afaraq,

Please explain the question once again, i didnt understand what is your requirement .
if you got it , please tell me how

My

 

[Afarag]

i have some data for some criteria from pivot table as shown, i want to insert an chart for each criteria and change
this chart via check box and so i want to set an object cal help me in sorting data ascending and descending