You use this dialog box the same way as you use the “Create PivotTable” dialog box to manually create a PivotTable. Excel then launches the “Create PivotChart” dialog box. Then select “PivotChart” to insert only a PivotChart or select “PivotChart & PivotTable” to insert both objects.
Then click the “PivotChart” drop-down button within the “Charts” button group. One way to create a PivotChart in Excel is to click the “Insert” tab within the Ribbon. After adding a PivotChart, you can then manipulate it the same way you manipulate PivotTable data. Alternatively, you can also add a PivotChart to an existing PivotTable if you didn’t create one when you initially created the PivotTable. You can create a PivotChart in Excel either independently from or along with an associated PivotTable in Excel. You can create a PivotChart in Excel to show the data from an associated PivotTable in a graphic format.
