Pinterest Pixel

Timeline Slicers In Microsoft Excel

Have a Pivot Table with dates involved? Did you know you can create a cool timeline slicer wherein... read more

Download Excel Workbook
Bryan
Posted on

Overview

Timeline Slicers In Microsoft Excel | MyExcelOnline Timeline Slicers In Microsoft Excel | MyExcelOnline

Have a Pivot Table with dates involved? Did you know you can create a cool timeline slicer wherein you can dynamically filter your data based on date ranges?

You will be blown away by what it can do! And with just a couple of clicks!

Our data has an Order Date column that we will use for the Slicer.

Timeline Slicers In Microsoft Excel

Timeline Slicers In Microsoft Excel | MyExcelOnline

Download excel workbookTimeline-Slicers.xlsx

 

STEP 1: Insert a new Pivot table by clicking on your data and going to Insert > Pivot Table > New Worksheet or Existing Worksheet

Timeline Slicers In Microsoft Excel

 

STEP 2: In the ROWS section put in the Sales Region field.  In the VALUES section put in the Sales field.

Timeline Slicers In Microsoft Excel

 

STEP 3: Let us now add our timeline slicer! Go to PivotTable Tools> Analyze > Filter > Insert Timeline

Timeline Slicers In Microsoft Excel

STEP 4: Make sure ORDER DATE is ticked. Click OK.

Timeline Slicers In Microsoft Excel

 

And now you have your Timeline Slicer! You can play around and set different date ranges, then the pivot table data will also adjust accordingly.

See also  Recommended Pivot Tables in Excel

Timeline Slicers In Microsoft Excel

See this example where we tried Jan 2012 – Mar 2012. You can also change the unit (e.g. months, years, etc.) of your slicer!

Timeline Slicers In Microsoft Excel

How to Create a Timeline Slicer in Excel

 

If you like this Excel tip, please share it
Timeline Slicers In Microsoft Excel | MyExcelOnline Timeline Slicers In Microsoft Excel | MyExcelOnline
Timeline Slicers In Microsoft Excel | MyExcelOnline
Bryan

Bryan is a best-selling book author of the 101 Excel Series paperback books.

Get Video Training

Advance your Microsoft Excel & Office Skills with the MyExcelOnline Academy!

Dramatically Reduce Repetition, Stress, and Overtime!
Exponentially Increase Your Chances of a Promotion, Pay Raise or New Job!

Learn in as little as 5 minutes a day or on your schedule.

Learn More!

Share to...