Charting a PivotTable

Data summarized in a PivotTable is an ideal candidate for a chart, since the table itself represents an overwhelming amount of data. A chart of a PivotTable is called a PivotChart . Once you select data within the PivotTable, you can chart it like any other worksheet data using the Chart Wizard. If you don't have a PivotTable, you can create a PivotChart and a PivotTable at the same time.

Create a PivotChart Report from a PivotTable Report

Click any data field in the PivotTable.

Click the Chart Wizard button on the PivotTable or Standard toolbar.

The PivotChart is created on a new worksheet.

Modify a PivotChart Report

Click the worksheet tab with the PivotChart you want to modify.

Click the Chart Wizard button on the PivotTable or Standard toolbar.

Make selections from each of the four Chart Wizard dialog boxes.

Click Finish.

Create a PivotChart Report with a PivotTable Report

Click any cell within the list range.

Click the Data menu, and then click PivotTable And PivotChart Report.

If using the list range, click the Microsoft Excel List Or Database option.

Click the PivotChart Report (With PivotTable Report) option.

Click Next to continue.

If the range does not include the correct data, click the Collapse Dialog button, drag the pointer over the list range, including the field names , to select a new range, and then click the Expand Dialog button.

Click Next to continue.

Click the desired location of the new PivotTable.

Click Finish.

Drag the data and fields you want from the PivotTable toolbar to the different area of the PivotChart.

The PivotTable is created as you create the PivotChart.