How to add a slicer to a pivot chart

Once you do that, the slicer will control both the pivot table and the pivot chart.

To add a slicer, select either the pivot table or the pivot chart.

You’ll find the Insert Slicer button on the Analyze tab for both.

it’s possible for you to use the shift key to extend your selection across more than one item.

Slicers come with their own menu on the ribbon that you’ll see only when you have one selected.

If you add another slicer to the same pivot chart, you’ll notice they are intelligently connected.

If you want to remove a slicer from a pivot chart, simply select and delete.