How to Create a Pivot Table Timeline in Microsoft Excel

  • google plus

In Brief...

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.

Instructions

  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.

Discuss