How to Create a Pie Chart in Excel from Pivot Table (2 Quick Ways)

Grouping data with Excel’s PivotTable makes it easy to summarize your data. Now, wouldn’t it be great to visualize this summary of your data in a chart? You’re in luck because this article demonstrates how to create a Pie Chart in Excel from Pivot Table.


Download Practice Workbook

You can download the practice workbook from the link below.


2 Ways to Create a Pie Chart from Pivot Table in Excel

First, let’s dwell a little upon what is a Pie Chart?

A Pie Chart is a circular graph where each slice of the pie represents the proportionate part of the entire data.

Generally speaking, in Microsoft Excel’s terminology, making a chart from a PivotTable is called a PivotChart, although it is the same as a normal chart.

Throughout this article, we’ll consider the following dataset shown in B4:D14 cells. Here, the first column shows the Item name, followed by the column for Category, and lastly, the Sales column in USD.

Dataset 1


1. Creating Pie Chart from Pivot Table 

Excel makes it simple to make a PivotTable and insert charts. So, without further delay, let’s see the process step-by-step.

📌 Step 01: Insert a Pivot Table

  • Firstly, select the dataset as shown below and go to the Insert > PivotTable.

Inserting Pivot Table

  • Next, a dialog box appears in which you have to check the New Worksheet option and press OK.

Inserting Pivot Table

  • Then, on the PivotTable Fields pane drag the Category and Sales fields into the Axis (Categories) and Values fields respectively.

Inserting Pivot Table

Just like that, a table is generated, it’s that easy.

How to Create a Pie Chart in Excel from Pivot Table Using Pivot Chart

  • In turn, you can format the numeric values by right-clicking the mouse and selecting the Field Value Settings.

How to Create a Pie Chart in Excel from Pivot Table Using Pivot Chart

  • Following, click the Number Format button.

How to Create a Pie Chart in Excel from Pivot Table Using Pivot Chart

  • Now, choose the Currency option. In this case, we chose 0 decimal places for the Sales value.

How to Create a Pie Chart in Excel from Pivot Table Using Pivot Chart

📌 Step 02: Create Pie Chart

  • Secondly, select any cell in the PivotTable.
  • Then, go to the PivotChart > Pie as shown in the image below.

How to Create a Pie Chart in Excel from Pivot Table Using Pivot Chart

📄 Note: You can also insert Pie Chart from Insert > Insert Pie or Doughnut Chart > Pie.

How to Create a Pie Chart in Excel from Pivot Table Using Pivot Chart

  • Next, you can format the chart by clicking on the Chart Elements option.

How to Create a Pie Chart in Excel from Pivot Table Using Pivot Chart

The results should look like the screenshot shown below.

How to Create a Pie Chart in Excel from Pivot Table Using Pivot Chart


2. Applying VBA to Insert Pie Chart from Pivot Table

While making a Pie Chart from PivotTable is easy, however, if you need to do it often, then you may consider the VBA code below. Just follow along.

📌 Step 01: Open the Visual Basic Editor

  • Firstly, go to the Developer > Visual Basic.

Navigate to Visual Basic Editor

📌Step 02: Insert the VBA Code

  • Secondly, navigate to Insert > Module where you’ll paste the VBA code.

Navigate to Visual Basic Editor

For your ease of reference, you can copy and paste the code from here.

Option Explicit
Sub CreatePivotTable()
Dim pt As PivotTable
Dim pc As PivotCache
Sheet3.Activate
Set pc = ActiveWorkbook.PivotCaches.Create(xlDatabase, Range("B4").CurrentRegion)
Sheets.Add , Sheets(Sheets.Count)
Set pt = ActiveSheet.PivotTables.Add(pc, Range("B4"), "Sales_Pivot")
pt.PivotFields("Category").Orientation = xlRowField
pt.PivotFields("Sales").Orientation = xlDataField
End Sub

Sub Piechart()
ActiveSheet.Shapes.AddChart2(251, xlPie).Select
ActiveChart.SetSourceData Source:=Range("$B$4:$D$14")
End Sub

VBA Code

💡 Code Breakdown:

Now, I will explain the VBA code used to generate Pie Chart. In this case, the code is divided into two sections.

Section 1: Explanation of CreatePivotTable () sub-routine

The explanation of the VBA code is provided below.

  • 1- Firstly, assign a name for the sub-routine.
  • 2- Secondly, define the variables.
  • 3- Thirdly Sheet3 is activated using the Activate method and the memory cache is assigned using the PivotCache object.
  • Additionally, we insert the PivotTable in a new sheet with the Add method.
  • 4- Finally, position the PivotTable in the B4 cell and give the name Sales_Pivot.
  • Moreover, we add the Pivot Fields i.e. the Category in the RowField and Sales in the DataField.

How to Create a Pie Chart in Excel from Pivot Table Using VBA Code

Section 2: Description of Piechart () sub-routine

In a similar fashion, the VBA code is explained below.

  • 1- In this section, give a name to the sub-routine.
  • 2- Next, the ActiveSheet property inserts the Pie Chart using the Shapes.AddChart2 method.
  • 3- Lastly, the SourceData property selects the data range for the Pie Chart.

How to Create a Pie Chart in Excel from Pivot Table Using VBA Code

📌 Step 03: Running the VBA Code

  • Thirdly, press the F5 key to run the CreatePivotTable () sub-routine.
  • Next, execute the Piechart () sub-routine.

How to Create a Pie Chart in Excel from Pivot Table Using VBA Code

Finally, the result should look like the picture below.

How to Create a Pie Chart in Excel from Pivot Table Using VBA Code


Conclusion

I hope this article helped you understand how to create a Pie Chart in Excel from Pivot Table. If you have any queries, please leave a comment below. Also, if you want to read more articles like this, you can visit our website ExcelDemy.

Eshrak Kader

Eshrak Kader

Hello! Welcome to my Profile. I completed my BSc. at Bangladesh University of Engineering & Technology from the Department of Naval Architecture & Marine Engineering. Currently, I am conducting research & posting articles related to Microsoft Excel. I am passionate about research & development and finding innovative solutions to problems.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo