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.

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.