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


PivotCharts are like regular charts, except they display data from a PivotTable. Just like regular charts, you'll be able to select a chart type, layout, and style that will best represent the data.

To create a PivotChart:

In this example, our PivotTable is showing each person's total sales per month. We'll use a PivotChart so we can see the information more clearly.

  1. Select any cell in your PivotTable.
    Screenshot of Excel 2013Clicking a cell in the PivotTable
  2. From the Insert tab, click the PivotChart command.
    Screenshot of Excel 2013Clicking the PivotChart command
  3. The Insert Chart dialog box will appear. Select the desired chart type and layout, then click OK.

    Screenshot of Excel 2013Choosing a chart type and clicking OK
  4. The PivotChart will appear.
    Screenshot of Excel 2013The inserted PivotChart

Try using slicers or filters to change the data that is displayed. The PivotChart will automatically adjust to show the new data.

Screenshot of Excel 2013Manipulating a PivotChart