Can you add a slicer to a chart in Excel?
Click anywhere in the PivotTable for which you want to create a slicer. This displays the PivotTable Analyze tab. On the PivotTable Analyze tab, click Insert Slicer. In the Insert Slicers dialog box, select the check box of the PivotTable fields for which you want to create a slicer.