how to create pie chart in excel for more data youtube

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

Read More: How to Group Small Values in Excel Pie Chart (2 Suitable Examples) As you can see we have now created our pie chart grouping all the data in excel.From the new window of “ Insert Chart” click “ Pie” and press OK.In this final step, we will choose data from the pivot table and go to “ Recommended Charts” from the “ Insert” option which will solved excel pie chart not grouping data.Step 3: Group Data in Pie Chart Using Recommended Charts Option Read More: How to Create a Pie Chart in Excel from Pivot Table (2 Quick Ways)

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

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

From the new window choose “ Existing worksheet” and select a location from the worksheet where you want to make your pivot table.

A new window will pop up named “ PivotTable from table or range”.

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

Step 2: Create a Pivot Table from Dataset Read More: How to Make a Pie Chart in Excel with One Column of Data

Then we will fill them with “ 1” to get the duplicates counted.

Firstly, we will start with entering a new column just by the side of the data table.

Step 1: Add a New Column to the Existing Dataset Now we will solve this problem with some easy and simple steps. Here we have our pie chart but as you can see the duplicates are not grouped in the chart. In the “ Insert Chart” window choose “ Pie Chart” and click OK to continue. Let’s select the dataset and insert a pie chart from the “ Recommended Charts” option. You will find some sales percentages are repeated in the data table. Suppose we have a dataset of a company’s global sales percentage in different countries. In the following article, I have shared 3 simple steps to solve excel pie chart not grouping data. 3 Simple Steps to Solve Excel Pie Chart Not Grouping Data Problem

How to create pie chart in excel for more data youtube