Forum Discussion
Slicer for line chart
Hi.
Is it possible to add a slicer to the below chart to hide/reveal each of the individual categories?
Thank you.
2 Replies
stusam check this out, if this fulfills your requirement.
Raw data :
first data is unpivoted:
than pivot table is created:
than pivot chart is created and slicer is added in pivot chart
Limitation : Only one field can be shown at a time.
some ideas are here
Slicer Controlled Interactive Excel Charts (myonlinetraininghub.com)
Use Excel Slicer Selection in Formulas • My Online Training Hub
Not exactly your case, but at least in this direction.
