How to Create PIVOT CHART in Excel


A PIVOT CHART is one of the best ways to present your data in Excel.

Why I’m saying this? Well, data in a visual way not only helps the user to understand it but it also helps you to present a clearer picture of it and you can make your point clear with led efforts.

And when we talk about Excel, there are numbers of charts which you use but there’s one of all those that STANDS OUT and that’s a PIVOT CHART.

If you are serious about taking your data visualization skills to a whole next level you need to learn to create a pivot chart.

And in the guide, I’ll be explaining to you all the details you need to know to understand how the pivot chart works.

But before that, here are some words from Wikipedia.

Pivot Chart is the best type of graphs for the analysis of data. The most useful feature is the possibility of quickly changing the portion of data displayed, like a PivotTable report. It makes Pivot Chart ideal for presentation of data in the sales reports.


Difference a Pivot Chart and a Normal Chart

different between excel pivot chart and normal excel chart
  • A standard chart use range of cells, on the other hand, a pivot chart is based on data summarized in a pivot table.
  • A pivot chart is already a dynamic chart, but you have to make changes in data to convert a standard chart into a dynamic chart.

Steps to Create a Pivot Chart in Excel

You can create a pivot chart by using two ways. One is to add a pivot chart in your existing pivot table, and other is to create a pivot chart from scratch.

1. Create a Pivot Chart from Scratch 

Creating a pivot chart from scratch is as simple as creating a pivot table. All you need, a data sheet.

Here I am using Excel 2013 but you use steps in all versions from 2007 to 2016.

  • Select any of the cells in your data sheet and go to Insert Tab → Charts → Pivot Chart.
insert excel pivot chart from insert tab
  • The pop-up window will automatically select the entire data range and you have the option to choose the place where you want to insert your pivot chart.
select place insert excel pivot chart
  • Click OK.
  • Now, you have a blank pivot table and pivot chart in a new worksheet.
blank pivot table and excel pivot chart

Important Note: When you insert a pivot chart it will automatically insert a pivot table along with it. And, if you just want to add a pivot chart, you can add your data into Power Pivot Data Model.

  • In pivot chart fields, we have four components like we have in a pivot table.
    • Axis: Axis in pivot chart is as same as we have rows in our pivot table.
    • Legend: Legend in pivot chart is as same as we have columns in our pivot table.
    • Values: We are using quantity as values.
    • Report Filter: You can use report filter to filter your pivot chart.
use chart fields to define value for excel pivot chart
  • So, here is your fully dynamic pivot chart.
create excel pivot chart from scratch

2. Create a Pivot Chart from Existing Pivot Table

If you already have a pivot table in your worksheet then you can insert a pivot chart by using these simple steps.

  • Select any of the cells from your pivot table.
select any cell to insert excel pivot table
  • Go to Insert Tab → Charts → Pivot Chart and select the chart which you want to use.
insert excel pivot chart if you already have pivot table
  • Click Ok.

It will insert a new pivot chart in the same worksheet where you have your pivot table. And, it will use pivot table rows as axis and columns as the legend in pivot chart.

Important Note: Another smart and quick way is to use shortcut key. Just select any of the cells in your pivot table and press F11 to insert a pivot chart.

More Information about Pivot Charts

Managing a pivot chart is simple and here is some information which will help you do it smoothly.

1. Change Chart Type

When you enter a new pivot chart, you have to select the type of the chart which you want to use. And, if you want to change the chart type you can use following steps for that.