Task 1 of 2
Build a PivotTable in F1: the sum of revenue by category.
Lesson theory
A PivotChart is built from a PivotTable and changes along with it: change a field in the rows or a filter, and the chart rebuilds (PivotTable Analyze › PivotChart).
The rule: do not include the "Grand Total" row in the chart. The total column is many times taller than the rest and makes the chart useless. Excel itself does not add the totals to a PivotChart.
In the trainer, a PivotTable is output as values, so build the chart from the PivotTable's cells without the total row; after the data changes, build the PivotTable again.
Practice is part of Pro
The live spreadsheet, task checking and .xlsx files in all 170 lessons. Your progress is saved in this browser; sync across devices is coming soon.