PivotTable timelines in Excel 2013

 May 28, 2015

Timelines are a new feature in Excel 2013. A timeline lets you filter records in a PivotTable – it works similar to a slicer, but you'll filter by dates. Once you have a PivotTable arranged, adding the timeline is simple:

  1. With the PivotTable selected, click the contextual “Analyze” tab.
  2. In the Filter group, click “Insert Timeline.”
  3. In the pop-up dialog box, check the date field (in this case, that’s Date) and click OK. Excel will embed the timeline alongside the PivotTable.

Use the new timeline with a PivotTable

To use the timeline, just drag the scroll bar or click a tile to further filter personnel totals by specific months. In the upper-right corner, you can change to years, quarters, months, and days. To clear the timeline filter, click the Clear button in the upper-right corner.

How do your Excel skills stack up?   

Test Now  

Tags

Excel 2013 Timeline Microsoft Excel microsoft excel PivotTables PivotTable timelines

How do
your Excel skills
stack up?

Grade your skills now

About the Author:

Alice Antonsen  

Alice is one of New Horizons’ most experienced Desktop Applications trainers. She is qualified with a Diploma of Business (Computing) and a Diploma of Information Technology. Since joining New Horizons in 2006, Alice has achieved the prestigious status of a certified Microsoft Office Master and for the past 4 years, has been placed in the Top 25 Desktop Applications trainers for New Horizons Worldwide. Throughout her career, she has gained a wealth of knowledge and experience in providing training to individuals and groups of varying skill levels. Alice delivers each training session with great care and consideration ensuring each one is tailored to the learning needs of her students.

Read full bio

Next up:

Previously

top