How to Create Pivot Chart in Excel

In this lesson, you can learn how to use a Pivot Chart.

Data preparation

Pivot Chart is similar to the traditional, but has some additional features useful for the analysis of data.

I have prepared table with sales data:

pivot chart sales data set

Ensure that your data is organized in a way that makes it easy to create pivot tables and pivot charts. This may involve creating a pivot table or using Excel’s sorting and filtering options.

Creativg Pivot Chart

Next go to Ribbon. Click Insert -> Pivot Table -> Pivot Chart

insert pivot chart

To create a pivot chart in Microsoft Excel, you need to first create a pivot table from your data. Dialog box appears. Choose here range of table with headers.

Create PivotTable

You can use the pivot table as the data source for a pivot chart. Now, you can create your own Pivot Chart.

pivot chart inserting

Choose fields which you want to put on the Pivot Chart.

pivot field list

Here’s how the Pivot Chart looks. In fact it is a better version of Column Chart.

pivot chart basic

Customize the appearance of your pivot chart to make it look professional and easy to understand. You can click Country or Customer button to filter values.

pivot chart filter

Excel inerted also a Pivot Table in your Spreadsheet.

pivot chart pivot table

You can change Pivot Chart by changing this Pivot Table. Pivot Chart shows the same values which you see in this Pivot Table.

Try to update / filter / change data in Pivot Table and see, how the Pivot Chart changed.

You can add a dashboard at this point. Combine all of your charts and graphs into a single dashboard by using Excel’s dashboarding features, such as “Sparklines” or “PivotCharts”.

See also  Yes No Chart with Non-numeric Data

Download free spreadsheet here