Analyze: Slicers

Slicers are a new way to filter the data in PivotTables and PivotCharts. The previous pages walked you through the steps of building a complex PivotChart with multiple filters. It is effective, but rather clumsy to work with.

 

The next couple of pages begin with a new PivotChart and demonstrates how you can use the Slicers.

 

1. Try it: Create a new PivotChart

Go to the Original Data spreadsheet.
Select All.
Go to
Insert-> Table-> PivotTable.

Click on PivotChart.

 

You will be asked to confirm the location of the data and whether you would like to place the new PivotChart in a new worksheet. Click OK. Keep going...

Exam 77-888: Microsoft Excel Expert 2010

3. Presenting Data Visually

3.4. Apply and manipulate PivotCharts

Insert-> Table-> PivotTable->PivotChart