[Solved]: Excel Pie Chart Not Grouping Data (with Easy Fix)

A pie chart is a graph that visualizes data in a circular diagram. It is mainly used to represent sales and financial calculations. In Microsoft Excel we often use it but sometimes we face problems with grouping data. In this article, I am going to share with you solved Excel pie chart not grouping data.

Excel Pie Chart Not Grouping Data: with Easy Fix

In the following article, I have shared 3 simple steps to solve Excel pie charts not grouping data. Stay tuned to learn more.

Suppose we have a dataset of a company’s global sales percentage in different countries.

You will find some sales percentages are repeated in the data table.

Excel Pie Chart Not Grouping Data

Let’s select the dataset and insert a pie chart from the “Recommended Charts” option.

In the “Insert Chart” window choose “Pie Chart” and click OK to continue.

Excel Pie Chart Not Grouping Data

Here we have our pie chart but as you can see the duplicates are not grouped in the chart. Now we will solve this problem with some easy and simple steps.

Step 1: Add a New Column to the Existing Dataset

  • Firstly, we will start by entering a new column just by the side of the data table.
  • Then we will fill them with “1” to get the duplicates counted.

Excel Pie Chart Not Grouping Data

Read More: How to Make Pie Chart by Count of Values in Excel

Step 2: Create a Pivot Table from Dataset

  • In this second step choosing the whole dataset, we will create a pivot table from the “Insert” option.

Excel Pie Chart Not Grouping Data

  • A new window will pop up named “PivotTable from table or range”.
  • From the new window choose “Existing worksheet” and select a location from the worksheet where you want to make your pivot table.
  • Press OK to continue.

  • From the right pane check mark all three options in the “Pivot Table Fields”.

Excel Pie Chart Not Grouping Data

  • Here we have successfully created our pivot table by grouping all the data.

Excel Pie Chart Not Grouping Data

Read More: How to Create Pie Chart Legend with Values in Excel

Step 3: Group Data in Pie Chart Using Recommended Charts Option

  • In this final step, we will choose data from the pivot table and go to “Recommended Charts” from the “Insert” option which will solve the Excel pie chart not grouping data.

Excel Pie Chart Not Grouping Data

  • From the new window of “Insert Chart” click “Pie” and press OK.

  • As you can see we have now created our pie chart grouping all the data in Excel.

Excel Pie Chart Not Grouping Data

Read More: How to Group Small Values in Excel Pie Chart

Things to Remember

  • You can group data by directly inserting a pivot table in the worksheet if you want. Here in the first step, I have added a new column to make a better understanding of the duplicates.

Download Practice Workbook


In this article, I have tried to cover all the simple steps and solve this problem. Take a tour of the practice workbook and download the file to practice by yourself. Hope you find it useful. Please inform us in the comment section about your experience. We, the Exceldemy team, are always responsive to your queries. Stay tuned and keep learning.

Related Articles

<< Go Back To Excel Pie ChartExcel ChartsLearn Excel

Get FREE Advanced Excel Exercises with Solutions!
Wasim Akram
Wasim Akram

Wasim Akram holds a BSc degree in Industrial and Production Engineering from Ahsanullah University of Science and Technology. Over the past 2 years, he has been actively contributing to the ExcelDemy project, where he has authored more than 150 articles. Now, he is working as an Excel VBA and Content Developer. He likes learning new things about Microsoft Office, especially Excel VBA, Power Query, Data Analysis, and Excel Statistics. He is also very interested in machine learning and... Read Full Bio

  1. That is silly that Excel has to make you do a pivot table in order to consolidate data for a chart. Makes no sense.

    • Dear Brenda,
      Thank you for your comment.
      In order to create a pie chart you don’t need to create a pivot table. But if your data have duplicate values then you must create a table to group those data and then create a pie chart. Otherwise the duplicate value will not group together. Because there’s no direct command or pivot pie chart in Excel to group data.
      There’s Pivot chart feature by which you can group data from pivot table fields and that is a column chart not pie chart. That’s why you need to create a table first and then create the pie chart.
      We’ll really appreciate your response If you have any alternative solution and share with us.

      Thanks & Regards
      Wasim Akram
      Team Exceldemy

Leave a reply

Advanced Excel Exercises with Solutions PDF