How To Create a Pivot Table Timeline in Excel 2013

News
By published

If you're tired of manipulating dates in your pivot table using clunky filter tools, Microsoft has finally provided a better way. Pivot table timelines allow you to quickly shift your pivot table according to dates and time, as well as zoom in and out of specific time periods. Fortunately, adding a timeline to your pivot table is no more difficult than a few clicks of the mouse. Just follow these steps to get started.

1. Click inside the pivot table to bring up the PivotTable Tools.

2. Click "Analyze" at the top of the screen.

3. Click "Insert Timeline" in the Ribbon.

4. Select the date you wish to use and press OK.

5. Adjust the timeline using the filter button. You can choose from Years, Quarters, Months or Days.

David Eitelbach
More about work collaboration tools
An illustration of a man's silhouette and the top of his head is open like a lid as a slew of app icons float out into the air. The illustration is on a flat orange background.

I found an app that connects all my apps — without trying to replace them. It's a life-changer.
Thunderbolt Share depiction

Intel Thunderbolt Share: The powerful PC-to-PC connection software is frustratingly elusive, but you don't need a new laptop to use it
Lenovo Thinkpad T440S

A Windows 11 update causes issues with some Lenovo laptops
See more latest