# How to Make a Pie Chart with Multiple Data in Excel (2 Ways)

Get FREE Advanced Excel Exercises with Solutions!

Pie Chart is one of the most popular ways to show your statistical data graphically. In Excel, we can make a Pie Chart with multiple data by using some simple steps. This article not only covers just how to make a Pie Chart with multiple data but also various ways of how we can customize and format our Pie Chart.

## What Is a Pie Chart?

A Pie Chart is a graphical representation of statistical data in the form of a pie. It is also known as the Circle Chart. In a Pie Chart, each portion of the pie is proportional to the fraction of the data provided. They are also sized according to their respective fractions.

For example, letâ€™s consider sales of flowers at a shop. With the help of a pie chart, we can show the sales of different flowers graphically.

Note: One thing to remember is that we will use Pie Chart for a relatively small amount of data. If the dataset is comparatively large, then the use of Pie Chart might not be a viable option. In that case, you may create a Pie Chart for sum by category if you find it necessary.

## How to Make a Pie Chart with Multiple Data in Excel: 2 Ways

In this section of the article, weâ€™re going to learn how to add a Pie Chart in Excel with multiple data points.

### 1. Using Recommended Charts Command

In the beginning, you can utilize the Recommended Charts command to make a Pie Chart in Excel with multiple data. In the following data set, we have Samuelâ€™s monthly expenses for different household activities. Now, we will add a Pie Chart to show this dataset graphically.

Steps:

• First, select the dataset and go to the Insert tab from the ribbon.
• After that, click on Insert Pie or Doughnut Chart from the Charts group.
• Afterward, from the drop-down choose the 1st Pie Chart among the 2-D Pie.

After that, Excel will automatically create a Pie Chart in your worksheet.

### 2. Making a Pie Chart with Multiple Data from Pivot Charts Option

In addition, we can easily make a Pie Chart from the PivotChart option by following some simple steps. As might be expected, we need to create a PivotTable before using the PivotChart feature.

In the following data set, we have monthly sales data of different categories of a grocery store. Letâ€™s create a Pivot Table and later on we will add a Pie Chart from that Pivot Table.

After following the steps of how to create pivot tables, we can get the following output.

Now, we will use the following steps to make a Pie Chart.

Steps:

• First, select the data set and go to the Insert tab from the ribbon.
• After that, click on the Pivot Chart from the Charts group.
• Now, select Pivot Chart from the drop-down.

• After that, select Pie from the Insert Chart dialogue box.
• Afterward, click OK.

Congratulations! You have successfully created a Pie Chart from a Pivot Table.

Read More:Â How to Make Pie Chart with Breakout in Excel

## How to Edit a Pie Chart

Excel gives us plenty of options to customize the Pie Chart. Now, we will learn some of the ways to format our Pie Chart.

### Editing Color of Pie Chart

To edit the color of a Pie Chart we can use the following steps.

Steps:

• First, click on any portion of the chart area. Then, the Chart Design tab will open.
• After that, click on the Change Colors option.
• Now, from the drop-down you can choose your preferred color.

### Customizing Style of Pie Chart

By following the below given steps, we can customize the Style of a Pie Chart.

Steps:

• First, click on the Pie Chart and Chart Design tab will be visible.
• After that, select your preferred Style of the Pie Chart from the marked portion of the following picture.

By following the above steps, you can easily edit the Color and Style of a Pie Chart.

### Formatting Data Labels

In Pie Chart, we can also format the Data Labels with some easy steps. These are given below.

Steps:

• First, to add Data Labels, click on the Plus sign as marked in the following picture.
• After that, check the box of Data Labels.

At this stage, you will be able to see that all of your data has labels now.

• Next, right-click on any of the labels and select Format Data Labels.

After that, a new dialogue box named Format Data Labels will pop up.

To edit the Fill and Border of background of the Data Labels select the Fill & Line tab.

You also have customization options for adding Shadow, Glow, Soft Edges,3-D Format under the Effects tab.

In the Size and Properties tab, you can adjust the Size and Alignment of the Data Labels.

Lastly, from the Label Options tab, you can adjust position of your Data Label, format the data type of the Data Label and so on.

## How to Make a Pie of Pie Chart

In this portion of the article, we will learn how we can create a Pie of Pie Chart. Usually, when some fractions of a Pie Chart are way lower than the higher ones, it becomes difficult to represent them properly in the normal Pie Chart. In that case, we use the Pie of Pie Chart.

In the following data set, we have Peterâ€™s monthly expenses for his various household activities. If we look closely into our data set, we can see that the bottom three values are way lower than the top 2 values. For this reason, it is a perfect opportunity to implement the Pie of Pie Chart.

To create a Pie of Pie Chart we will use the following steps.

Steps:

• First, select the entire data set and go to the Insert tab from the ribbon.
• After that, choose Insert Pie and Doughnut Chart from the Charts group.
• Afterward, click on the 2nd Pie Chart among the 2-D Pie as marked on the following picture.

Now, Excel will instantly create a Pie of Pie Chart in your worksheet.

If you need, you can also tell Excel how many of the bottom values you want to show in the 2nd Pie Chart.

You can do this by using the following steps.

Steps:

• First, right-click on any part on the Pie Chart.
• After that, select Format Data Series.

• Now, in the Format Data Series dialogue box go to Values in second plot option.

After that, you can increase or decrease the number of values you want to show in the Second Pie Chart.

Read More:Â How to Make a Pie Chart in Excel with Words

## Things to Remember

• To make the Chart Design tab visible, you must click anywhere on the Pie Chart.
• While editing the Pie of Pie Chart, make sure that you right-click on the Pie Chart inside the chart area. Otherwise, the Format Data Series option will not be visible.

## Conclusion

Finally, we have come to the very end of the article. I really hope that this article was able to guide you so that you can make and customize a Pie Chart in Excel with multiple data points. Please feel free to leave a comment if you have any queries or recommendations for improving the articleâ€™s quality. To learn more about Excel, you can visit our website, ExcelDemy. Happy learning!

## Related Articles

<< Go Back To Make a Pie Chart in Excel | Excel Pie Chart |Â Excel Charts |Â Learn Excel

## What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Zahid Hasan

Zahid Hassan, BSc, Industrial and Production Engineering, Bangladesh University of Engineering and Technology, has worked with Exceldmy for 1.5 years. He has written 95+ articles for Exceldemy. He has worked as an Excel & VBA Content Developer. He also worked as a VBA Developer for the Template team. Currently, he is working as a Junior Software Developer for the Excel Add-in project. He is interested in Software Development, Python, VBA, VB.NET, and Data Science, expanding his expertise in... Read Full Bio

We will be happy to hear your thoughts

Advanced Excel Exercises with Solutions PDF