Excel: Timeline in Excel 2013

This page is an advertiser-supported excerpt of the book, Power Excel 2010-2013 from MrExcel - 567 Excel Mysteries Solved. If you like this topic, please consider buying the entire e-book.


Excel 2013 introduced a new type of filter called a Timeline. It only works for date columns. You can choose to filter by Day, Month, Quarter, or Year.

  1. Timelines are new in Excel 2013 pivot tables.

    As in the previous topic, you can run many pivot tables from one Timeline.