Instead of choosing the exact items you want to see, you can add a condition. This works for data that includes numbers, text, and dates. Let’s look at an example of each. Follow the same steps above ...

Step 3: Format Your Timeline Filter Go One Step Further: Add a PivotChart One way to display figures in an Excel table according to certain time periods is by using filter buttons.

6. Set up a new filter. If there are rows in your table that don’t get filtered, try setting up a new filter. To do so, select the Data tab. Click the Clear button within the Sort & Filter group. Then ...

Slicers are a good way to filter data in a Microsoft Excel PivotTable or PivotChart, but they take up a bit of room. By moving the buttons to the chart, you free room for more visuals.