Chat with us, powered by LiveChat

Pivot Table Timeline

How to Add a Timeline in Excel

Timelines are interactive filters that let you quickly filter by date. They make it quick and easy to see PivotTable data for only the time period you specify. They are similar to slicers in that you can insert them once and keep them with the PivotTable to update at will.

Insert a Timeline

  1. Click any cell inside the PivotTable.
  2. Click the Analyze tab on the ribbon.
  3. Click the Insert Timeline button.

    You can also insert a Timeline for PivotCharts and cube functions.

    The Insert Timelines dialog box appears. It automatically detects the date fields used in the PivotTable and has them available for you to select from. Many times, there will only be one available field.

  4. Select the date field you want to use for the timeline.
  5. Click OK.
    Timelines
  6. Select a time span in the Timeline you want the PivotTable to display.
    Timelines

    To select multiple intervals, you can click and drag along the timeline or click the first interval you want to include and hold the Shift key while clicking the last interval in your chosen span.

Clear a Timeline

You can clear the Timeline at any point to restore all the data in the PivotTable.

  1. Click the Clear Filter button at the top-right corner of the Timeline.
    Timelines

All the PivotTable data is visible once again.

Remove a Timeline

If you no longer need to use the Timeline, it can be removed from the sheet entirely.

  1. Right-click the timeline.
  2. Select Remove Timeline
    Timelines

The timeline is removed from your PivotTable.