Excel 2013 new feature: Timeline Slicer


Ask Quincy

What’s New in Excel 2013?  Timeline Slicers !

Timeline Slicers are a feature new to Excel 2013.
If your PivotTable contains dates, a Timeline Slicer affords you and your reviewers an easy method to filter and scale of the dates displayed..

(For detailed instructions on creating PivotTables review the 5 minute video tutorial  PivotTables and Slicers )

Inserting the Timeline Slicer

  1. Click hereto open the file PivotTable Advanced Functions.xls file.
  2. Review the Sales sheet. This is the source of our PivotTable data.
  3. Click the Summary Sheet. A PivotTable has already been inserted, with the dates of Weekly Sales displayed in Rows, and a Slicer for the Category field applied.
  4. Select one of the cells containing data (e.g. A4).
  5. On the Ribbon, on the PIVOTTABLE TOOLS: ANALYZE tab, in the Filters group, click Insert Timeline. The Insert Timelines dialog appears.
  6. Check Weekly Sales and click OK.

View original post 67 more words