Using Slicer and Timeline together

Office for Mere Mortals helps people around the world get more from Word, Excel, PowerPoint and Outlook. Delivered once a week. free.


PivotTable Slicers and Timelines can be combined to filter by time and other criteria in Excel.

using slicer and timeline together 15974 - Using Slicer and Timeline together

Let’s first add a slicer to filter the data by following the below steps:

  1. Click inside the PivotTable and go to the Analyze tab
  2. Click Insert Slicer under the filter group.
    using slicer and timeline together 15975 - Using Slicer and Timeline together
  1. From the Insert slicer dialog box, choose the field option you want to filter by and Click OK.

    using slicer and timeline together 15976 - Using Slicer and Timeline together

  2. You will now see the slicer next to the timeline in the spreadsheet.

Team up Slicer and Timeline

Let’s see how you can use the slicer and the timeline together. With the new slicer, you can quickly filter the data by Category and dates. To see how this works, Select on any Category in the slicer. Then, click any quarters you want to view the sales for.

using slicer and timeline together 15977 - Using Slicer and Timeline together

You can always go ahead and use a slicer to filter the PivotTable, with or without the timeline.

using slicer and timeline together 15978 - Using Slicer and Timeline together

When you have the timeline tiles selected, the slicer will reflect the values for those time periods. You may at any time decide to remove the selected timeline filter by clearing the filter option on the timeline.

 

 


Want More?

Office Watch has the latest news and tips about Microsoft Office. Independent since 1996. Delivered once a week.