Excel Tutorials

In this tutorial, I’ll show you how to create a chart from a Pivot Table.

1. Next, you can create a chart just as quickly as you formatted the table.
2. 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.”
3. 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.

Posted in Pivot Tables | Comments (0)