how to make a pie chart in excel with group

Even though Excel is very powerful to help you solve many problems, Excel itself still has many errors.

And Excel will also corrupt due to many reasons. Excel cannot Escape Data Disasterĭata disaster will happen to every computer users. If you need to show all data sets of all the classifications, you can consider using other types of chart. Besides, the pie of pie chart can only have one subset of a certain classification. You can also make other modifications for the chart according to your need. With data labels in the chart, you will not mix up those data sets in this pie of pie chart.

In the drop-down menu, choose an option to add data labels for the chart.

And then click the button “Data Labels” in the toolbar.

Next you can modify the chart according to your need.

And then you will see the chart appear in the worksheet.

In the drop-down list, choose the chart “Pie of Pie”.

Next click the button “Pie” in the toolbar.

Then click the tab “Insert” in the ribbon.

After that, place the cursor within the range.

When you finish the setting, your worksheet will be like the image below.

And then delete the number of the Season 4.

Copy the information of sales representative under the first range in the worksheet.

Before you create such a chart, you need to rearrange the worksheet.

The steps to create a pie of pie chart are very easy. Therefore, you can choose to create a pie of pie chart.

Now your task is to display all the information in one chart. There are sales volumes of each sales representative. Except for the sales volume in each season, you can also see the subset of the last season. The image below shows the sales volume of a product. But do you know that you can also create a pie of pie chart in your worksheet? With such a chart, not only can you display certain data and information, but also you can see the subset of a certain classification. Pie chart can well present the relationship of each data set. In this article, we will introduce you the pie of pie chart in Excel. Chart in Excel can reflect data and information more intuitive.

How to make a pie chart in excel with group