Mar 12 2024 01:36 AM
Hi.
Is it possible to add a slicer to the below chart to hide/reveal each of the individual categories?
Thank you.
Mar 12 2024 02:27 AM
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.
Mar 12 2024 04:53 AM
@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.