- Next, you can create a chart just as quickly as you formatted the table.
- Go to the floating pivot table menu and click on the button labeled “Chart Wizard” or click on the pivot table drop down menu and select the “Chart Wizard.”
- By just clicking on the “Chart Wizard” option, Excel creates a chart in a second and you will see it saved in a separate spreadsheet labeled “Chart1” – which you can rename later.
Fantastic! Now you know just how easy it is to create a Pivot Table Chart.