How To Create a Pivot Table Timeline in Excel 2013

  • MORE

how to create tmieline 1 lead 675403

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.

how to create tmieline 1 click pivottable 675403

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

how to create tmieline 2 click analyze 675403

3. Click "Insert Timeline" in the Ribbon.

how to create tmieline 3 click insert timeline 675403

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

how to create tmieline 4 select date 675403

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

how to create tmieline 4 adjust timeline

Recommended by Outbrain
Add a comment
1 comment
  • Marilyn Williams Says:

    Great information!!

    But how about taking it to the next level? It would be greatly appreciated if articles like these included a file to download with the sample data so that we could play with it.