Creating PivotTables

Use pivot tables in Excel for stronger data analysis. This Excel pivot table tutorial also helps you summarize data.

Using a PivotChart

A PivotChart is like a regular chart, except it displays data from a PivotTable. As with a regular chart, you'll be able to select a chart type, layout, and style to best represent the data. In this example, we'll use a PivotChart so we can visualize the trends in each sales region.

To create a PivotChart:

  1. Select any cell in your PivotTable. The Options tab will appear on the Ribbon.
  2. From the Options tab, click the PivotChart command.
    The PivotChart commandThe PivotChart command
  3. From the dialog box, select the desired chart type (3-D Clustered Column, for example), then click OK.
    Selecting a chart typeSelecting a chart type
  4. The PivotChart will appear in the worksheet. If you want, you can move it by clicking and dragging.
    A PivotChartA PivotChart

If you make any changes to the PivotTable, the PivotChart will adjust automatically.