Microsoft Office Tutorials and References
In Depth Information
Tip 83: Using Pivot Table Slicers and Timelines
Using Pivot Table Slicers and Timelines
If you’ve worked with pivot tables, filtering data in a pivot table is fairly easy. Just click the filter
button for a field, and remove the check mark from items that you don’t want to see. This tip describes
two ways to simplify pivot table filtering: slicers and timelines. These methods are most useful when
the worksheet will be viewed by novices, or for those who prefer things very simple.
Figure 83-1 shows an unfiltered pivot table that summarizes bank account information by three
fields: Customer Type (either New or Existing), Branch (either Central, North County, or Westside),
and OpenedBy (either New Accts or Teller).
Figure 83-1: The normal way to filter items in a pivot table.
A slicer is an interactive control that makes it easy to apply simple filters to data in a pivot table.
Figure 83-2 shows a pivot table with three slicers. Each slicer represents a particular field in the pivot
table. In this case, the pivot table is displaying data for existing customers, opened by tellers at the
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. Slicers can also
be used to create an attractive and easy-to-use interactive dashboard.