How to Create a Pivot Table Timeline in Microsoft Excel

The following seven steps show how to create a pivot table timeline for filtering your Excel data by time.

This feature works the same in Microsoft Office 2013 and 2016.

1. Click the pivot table.
2. From the PivotTable Tools Analyze tab, in the Filter group, select Insert Timeline.
3. In the Insert Timeline dialog box, check the check box of the date fields you want in the timeline.
4. The timeline is displayed. To filter by date, click the arrow next to the time section and make a selection.
5. Drag the scrollbar to see the filtered data.
6. To see a specific time period, click and drag the timeline handles.
7. Click the Clear Filter button to clear the timeline.