Excel > Excel 2003 Advanced > PivotTables and PivotCharts

Creating a PivotChart

A PivotChart can be created to plot the data from a PivotTable and provide a graphical representation. PivotChart's are interactive and their layout can be changed just like you would with a PivotTable.

  1. Select a cell in the PivotTable
  2. Click the Chart Wizard button on the PivotTable toolbar
  3. Chart Wizard button

    If the PivotTable toolbar is not displayed, right click on any toolbar button and select PivotTable from the list of toolbars that appears.

  4. A chart is inserted onto a new worksheet
  5. PivotChart report

The Chart toolbar appears providing features to help you work with the PivotChart.

If the PivotTable is updated, the PivotChart will automatically update to plot the latest data.

Follow us on

Facebook  Twitter  You Tube