Microsoft Office Tutorials and References
In Depth Information
Creating a Timeline Slicer
After your Timeline slicer is created, you can filter the data in your pivot table and pivot chart, using
this dynamic data selection mechanism. Figure 16-19 demonstrates how selecting Mar, Apr, and May
in the Timeline slicer automatically filters the pivot chart.
Figure 16-19: Click a date selection to filter your pivot table or pivot chart.
Figure 16-20 illustrates how you can expand the slicer range with the mouse to include a wider range
of dates in your filtered numbers.
Figure 16-20: You can expand the range on the Timeline slicer to include more data in the filtered numbers.
Want to quickly filter your pivot table by quarters? Well, that’s easy with a Timeline slicer. Simply click
the time period drop-down menu and select Quarters. As you can see in Figure 16-21, you also have
the option of switching to Years or Days, if needed.