Using Timeline Slicers in Excel 2013

0 Flares 0 Flares ×

Timeline Slicers are a new addition to Excel 2013. They are a new filter tool that is available exclusively to the date fields in your PivotTables. They are visually appealing and easy to use.

To use a Timeline with your PivotTable;

  1. Click anywhere inside your PivotTable.
  2. Click the Analyze tab on the Ribbon under PivotTable Tools and then click the Insert Timeline button from the Filter group (Timeline can also be found on the Insert tab. Expect to see further use for it in future versions of Excel).
  3. The Insert Timelines dialog box appears. Select the date fields that you want to use by checking the boxes and clicking Ok.

Choose a date field for your Timeline Slicer

  1. The Timelines Slicer is inserted. Use it by clicking on the timeframe that you want to view. You can also click and drag the ends of the selection to expand the date range visible in the PivotTable.

Timeline filtering a PivotTable by quarters

  1. You can change the time period being used by the Timeline by clicking on the Time Level list in the top right corner and choosing a different time period.

Changing the Time Period in  the Timeline

  1. Got more than one PivotTable? Click the Report Connections button on the Options tab on the Ribbon under Timeline Tools.

Check the boxes for the reports that you want your slicer to be able to filter.

Connect the Timeline Slicer to multiple PivotTables

Timeline Slicers are a great new feature to Excel 2013. They make filtering PivotTable data by a date ranges easier, more fun and far more appealing than past versions of Excel offered.

Watch the Video

4 thoughts on “Using Timeline Slicers in Excel 2013

  1. It would be nice if one of these timeline slicer examples came out of the closet and said, “this does not work for fiscal calendars”.


  2. Thank You so much for the details you have provided. You are so clear with your examples and instructions. I am trying but so far, no results. I understand your steps but…
    I am from Cincinnati, OH USA and it is amazing to know that you are helping from the UK – Thanks!
    We have a timeline that we have set up in Excel 2013 with Date, Milestone & position. Somewhere the format is placing dates we have not placed in our details. I am trying to remove unneeded dates to make the timeline more compact and complete!

Leave a Reply

Your email address will not be published. Required fields are marked *