A chart from a PivotTable
To compare managers, the simplest thing is to draw a chart right from the orders table. But you get a mess:
It has twelve columns, one per order. Emma has four of them, Leo has three, and you can't tell by eye who's ahead.
PivotTable first, chart second
A chart draws the rows of a table as they are: as many rows, as many columns. It doesn't add anything up by itself. Adding up orders by manager is what a PivotTable does, so you build the report first and then create the chart from it. Below, the report by manager is already built, and all that's left is to draw it:
The Grand Total row isn't on the chart. Excel doesn't draw a total next to the parts it's made of: next to it, the other columns would become very short.
A chart from a PivotTable is linked to the report, not to the orders table, which is why it was rebuilt right after the report. If you change a number in the source table, refresh the PivotTable first: on the PivotTable Analyze tab, click Refresh, and the chart is redrawn right after it.
Excel took the title "Sum of Revenue, $" from the report. If someone else will see the chart, rename it the same way as any other: double-click the title.
Twelve orders in the table or twelve thousand, a chart like this still has one column per manager. The PivotTable does the adding up, and the chart only draws its report.
The last task below the lesson brings the whole course together: prices with VLOOKUP, totals with a formula, a PivotTable and a chart from it. After that, try the same thing on your own data: open the sandbox, click Open .xlsx and upload your own export. To keep the techniques fresh, solve a few tasks at a time in the trainer.