Excel provides several ways insert a pivot table and pivot chart in one step.
First, try Recommended Charts.
This icon represents a pivot chart.
In that case, use the Pivot Chart button on the Insert tab of the ribbon.
When you click OK, you’ll get a new blank pivot table and blank pivot chart.
From there, you’ve got the option to add fields to either to build the chart.
Recommended charts will show you previews of chart options, although strangely the pivot table icon is missing.
When you choose an option, you’ll get a new pivot chart linked to the pivot table.
I’ll undo that and let’s try the Pivot Chart button.
Again double-check you select a cell in the pivot table first.
This menu only appears when a pivot table is selected.
When you use this button, the options you see are exactly the same.
