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

  3. In the Insert Timeline dialog box, check the check box of the date fields you want in the timeline.
    Check Date Fields

  4. The timeline is displayed. To filter by date, click the arrow next to the time section and make a selection.
    Make Selection

  5. Drag the scrollbar to see the filtered data.
    Drag Slider

  6. To see a specific time period, click and drag the timeline handles.Drag Handles

  7. Click the Clear Filter button to clear the timeline.
    Click Clear Filter
Author: Margaux Judge

Margaux Judge has worked as an e-learning editor and instructional designer for over ten years, writing and editing a wide variety of courses, from technical topics to soft skills. She has a Bachelor's degree in English and Textual Studies from Syracuse University and a Master's degree in Television Writing from Boston University.

About Webucator

Webucator provides instructor-led training to students throughout the US and Canada. We have trained over 90,000 students from over 16,000 organizations on technologies such as Microsoft ASP.NET, Microsoft Office, Azure, Windows, Java, Adobe, Python, SQL, JavaScript, Angular and much more. Check out our complete course catalog.