Microsoft Office Tutorials and References
In Depth Information
Filtering Pivot Tables with Slicers
Filtering Pivot Tables with Slicers
A slicer makes it easy to filter data in a pivot table. Figure 18-38 shows a pivot table with three
slicers. Each slicer represents a particular field. In this case, the pivot table is displaying data for
New customers, opened by Tellers at the Westside branch.
Slicers are new to Excel 2010.
The same type of filtering can be accomplished by using the field labels in the pivot table, but
slicers are intended for those who might not understand how to filter data in a pivot table. You
can also use slicers to create an attractive and easy-to-use interactive “dashboard.”
Figure 18-38: Using slicers to filter the data displayed in a pivot table.
To add one or more slicers to a worksheet, start by selecting any cell in a pivot table. Then
choose Insert Filter Slicer. The Insert Slicers dialog box appears, with a list of all fields in the
pivot table. Place a check mark next to the slicers you want, and click OK.
To display multiple values, press Ctrl while you click the buttons in a slicer.
The slicers can be moved and resized, and you can change the look. To remove the effects of
filtering by a particular slicer, click the icon in the slicer’s upper-right corner.
Figure 18-39 shows a pivot table and a pivot chart. A slicer is used to filter the data by state — a
quick and easy way to create an interactive chart.
This workbook, named pivot chart slicer.xlsx , is available on the companion
Search JabSto ::

Custom Search