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.

In this tutorial, I’ll show you how to add multiple grand totals to a PivotTable. SEE: Google Workspace vs. Microsoft 365: A side-by-side analysis w/checklist (TechRepublic Premium) ...