Let’s move on and build a PivotTable to support the PivotChart (Figure A). How to build the PivotTable in Excel Thanks to the data structure, the PivotTable will be simple to build.

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.