Step 4: You can see a slicer added under your excel table with all country labels. Click the OK button after selecting the Country as a slicer.
![excel how to add slicer to filter by time excel how to add slicer to filter by time](https://www.myexcelonline.com/wp-content/uploads/2016/03/Slicer-07-1.png)
I will choose Country as a slicer option and see what happens. Inside it, you can have all the columns present in the table and can use any of them as a slicer. Step 3: You click on the Insert Slicer button under the Tools option inside the Design tab, you’ll see an Insert Slicer window. It will allow you to add slicers to the table. Click on the Insert Slicer button under the Tools section inside the Design tab.
EXCEL HOW TO ADD SLICER TO FILTER BY TIME SERIES
Step 2: Click on the Design tab, and you’ll be able to see a series of options available under it.
![excel how to add slicer to filter by time excel how to add slicer to filter by time](https://peltiertech.com/images/2014-04/Pivot-Chart-Formatting-Changes-by-Filter-Slicer-Excel.gif)
Your table should look like the one shown in the screenshot below.Īs soon as you insert a table, you’ll be able to see a new tool added on the right-hand side of the upper ribbon pane under the Table Tools option named as Table Design. It will pop up a new window called Create Table with all the ranges we have selected to insert Table.
![excel how to add slicer to filter by time excel how to add slicer to filter by time](https://support.content.office.net/en-us/media/5ca158fc-9405-45d4-9ddb-373199168ae4.jpg)
Suppose we have data of sales for the past two years as shown below: Example #1 – How to Insert Slicer under Tables in Excel Let’s understand how to Insert Slicer in Excel with some examples. Excel functions, formula, charts, formatting creating excel dashboard & others How to Insert Slicer in Excel?