Create a Pivot Chart With the Chart Wizard

If you select a cell in a pivot table and click the Chart Wizard button on the toolbar, a default pivot chart is created, on a new chart sheet. Sometimes you might want to step through the Chart Wizard, so you can set the options as you create the pivot chart.

Use the Chart Wizard

If you follow these steps, you can use the Chart Wizard, instead of creating the default pivot chart.

  1. Select an empty cell on the worksheet, away from the pivot table and any other data.
  2. On the Excel toolbar, click the Chart Wizard button.
  3. In Step 1 of the Chart Wizard, select a Chart type and Chart sub-type, then click Next.
  4. In Step 2 of the Chart Wizard, click in the Data range box, and select any cell in the pivot table. The entire pivot table will be automatically selected, and its address will appear in the Data range box.
  5. Complete the remaining Chart Wizard steps, selecting the options you want, then click Finish to create the pivot chart.

Note: If you select a pivot table as the data range, you can’t return to Step 2 of the Chart Wizard. To use a different data range, create a new chart.