Use Slicers to Filter the Data

Before You Begin: Click on the PivotChart. The PivotChart Tools should be available.

 

1. Try it: Insert Slicers

Go to PivotChart Tools ->Analyze-> Data.

Click on Insert Slicer.

 

 

What Do You See? You will be prompted to select the Fields you want to include.

Select the following fields:

Category

Product

 

Please click OK. Keep going...

Exam 77-888: Microsoft Excel Expert 2010

3. Presenting Data Visually

3.4. Apply and manipulate PivotCharts: Analyze data with Slicers

PivotChart Tools ->Analyze ->Data-> Insert Slicers