Forum Discussion
drop down instead slicer
Based on my example:
1. Create a slicer in sperate sheet (Product)
2. Create another Pivot Table and drop only ( Product) in the filter section
3. Under the Slicer Report connection, make sure both pivot are connected to the slicer.________________________
Did I answer your question? Mark this post as a solution, this will help others!.
I accept KUDOS 🙂
vjnvinod
Please check the attached file. I hope you wanted to filter a chart by a drop-down instead of a slicer.
https://1drv.ms/x/s!AmoScH5srsIYgYI-_rdNDaruJbdTXQ?e=a01Ewf
________________________
Did I answer your question? Mark this post as a solution, this will help others!.
I accept KUDOS 🙂
this helps
but actually i was looking for drop down something like below
basically List box from the form control
is it possible?
vjnvinod
The solution I provided works, so kindly accept this as a solution and post this in the forum below as it related to Excel.
https://www.mrexcel.com/board/
Thanks________________________
Did I answer your question? Mark this post as a solution, this will help others!.
I accept KUDOS 🙂
sure
i think it make sense
but can you just let me know how you did that?
Can you give me the steps?
and i close this thread?
Based on my example:
1. Create a slicer in sperate sheet (Product)
2. Create another Pivot Table and drop only ( Product) in the filter section
3. Under the Slicer Report connection, make sure both pivot are connected to the slicer.________________________
Did I answer your question? Mark this post as a solution, this will help others!.
I accept KUDOS 🙂