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 🙂
thank you
but unfortunately it doesn't helps my client is little adamant to not use slicer for pivot charts
is there a way i can create a drop down and connect my pivot charts using some excel macros?
thanks Fowmy
i am actually not allowed to share any contents here
is it possible for you to share me a sample of couple of pivot charts connecting to drop downs
and accordingly i can to replicate that codes in my model?
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 🙂