Get instant live expert help with Excel or Google Sheets
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Our professional experts are available now. Your privacy is guaranteed.
All articles PIVOT TABLE How to Create a Pie Chart from a Pivot Table

How to Create a Pie Chart from a Pivot Table

We can easily create a Pie chart from a Pivot Table by using the Charts feature in excel. This enables us to visualize trends and make comparisons in our data. The steps below will walk through the process of creating a Pie Chart from a Pivot Table.

Figure 1- How to Create a Pie Chart from a Pivot Table

Setting up the Data

  • We will use the Grouped Sales data by Month in the Pivot Table of figure 2 to create a pie chart

Figure 2 – Setting up the Data

Creating the Pie Chart

  • We will click on anywhere within the Pivot Table
  • We will click on the Insert tab
  • We will click on the Pie Chart icon in the Charts section and select the type of Pie Chart we want

Figure 3- Click on Pie Chart Icon

Figure 4- Created 3-D Pie Chart

Figure 5- Created Doughnut Pie Chart

Instant Connection to an Expert through our Excelchat Service

Most of the time, the problem you will need to solve will be more complex than a simple application of a formula or function. If you want to save hours of research and frustration, try our live Excelchat service! Our Excel Experts are available 24/7 to answer any Excel question you may have. We guarantee a connection within 30 seconds and a customized solution within 20 minutes.

Leave a Comment

avatar

Subscribe to Excelchat.co

Get updates on helpful Excel topics

Subscribe to Excelchat.co
Trusted by people who work at
Amazon.com, Inc
Facebook, Inc
Accenture PLC
Siemens AG
Macy's
The Allstate Corporation
United Parcel Service
Dell Inc