How to create pivot chart in Excel?

Pivot charts are an advanced visualization tool in Excel, offering better data analysis compared to regular charts. This tutorial provides a step-by-step guide on how to create and customize a pivot chart in Excel.

Create pivot chart in Excel

Create pivot chart in Excel

To create a pivot chart, follow these steps:

1. Select the base data, and click Insert > PivotChart > PivotChart. See screenshot:

2. In the popping Create PivotTable with PivotChart dialog, choose where you want to place the new PivotTable and PivotChart under the Choose where you want the PivotTable and PivotChart to be placed section. See screenshot:

3. Click OK. Now a PivotTable Field List displays in the left of the worksheet.

4. Now drag the fields you want to show in the PivotChart to the areas as you need. Here, I drag the Saler and Order ID fields to the Axis Fields (Categories) section and the Amount field to the Values section. See screenshots:

Note: When you create a pivot chart, a pivot table is created at the same time.

Tip:

If you want the legend series shown as Saler, you can drag Saler field to the Legend Fields (Series) section. See screenshots:

You can filter the Order ID or Saler by clicking the down arrow in PivotChart, specify the filter criteria in the drop down list, and then click OK.

Note: The PivotTable will update automatically as the PivotChart changes.

Related Articles:

• Create pivot table in Excel 2007/2010/2013
• Add secondary axis in PivotChart