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...