See all How-To Articles

How to Make a Pivot Table Chart in Excel

This article will demonstrate how to make a Pivot Table Chart in Excel.

pivotchart intro

 

Creating a Pivot Chart

A Pivot chart is similar to a chart created from a table of data, except that it is based on a Pivot Table.

1. Click in your Pivot table, and then, in the Ribbon, select PivotTable Analyze > Pivot Chart.

pivotchart ribbon

2. First (1) Select the type of chart you wish to create (column, line, bar, etc.), and then (2) select the style of chart (eg Clustered Column).    To insert the chart into your worksheet (3) click OK.

pivotchart insert chart

3. Your chart will be placed into your sheet.  If you wish to move the chart, click in the middle of the chart – your mouse should then have a small black cross attached to it – drag your chart to your desired location on your sheet.

pivotchart move chart

Drill Down in a Pivot Chart

The chart will display all the information that is shown in the Pivot table.  You can either filter (drill down) in the Pivot table or in the Pivot Chart.   In our example, we can click on the drop down arrow to the right of the Filter field (Years), to drill down to a specific year.

  1. Click on the Drop down arrow to the right of the Filter field.
  2. Select the value required (2021).
  3. Click OK.

pivotchart drill down

The data in both the Pivot Chart and the Pivot table will be filtered.

pivotchart filtered

Changing the Chart Type

1. Click in your chart, and then, in the Ribbon, select Design > Change Chart Type.

pivotchart chart type

2. Select the type of chart you require, and then click OK.

pivotchart change charge type

3. Your chart will be updated.

pivotchart updated chart

Printing the Pivot Chart

To print just the Pivot Chart, excluding the Pivot table, you can click just on the chart and then, in the Ribbon, select File > Print.

pivottable print chart

To print the sheet so that both the Pivot table (and/or other content) and the chart are shown, click OFF the chart so that your mouse pointer is clicked on a cell in the worksheet. Then in the Ribbon, go to File > Print.

pivotchart print sheet