How to Create a Pie of Pie Chart in Excel: Visualize Data with Two Data Sets

A Pie Chart is one of the most popular data visualization tools used in Excel to display data in a circular form. However, when you have a lot of small values, they can be hard to differentiate in a standard pie chart. This is where the pie of pie chart with two data sets in Excel comes into play. It breaks down the smallest portions of your data into a secondary pie chart, giving more clarity to the data that would otherwise be hard to see. In this article, we will show you how to create a Pie of Pie chart in Excel, customize it, and use it for better data visualization in your spreadsheets.

What is a Pie Chart in Excel

A Pie Chart is a type of circular statistical graphic that is used to represent data visually. It is divided into slices to illustrate numerical proportions, where each slice represents a category's contribution to the whole. The size of each slice is proportional to the quantity it represents.

Types of Pie Charts in Excel

Excel offers various types of pie charts to better display your data. These include:

Pie: The basic pie chart displaying a single pie.

Exploded Pie: A pie chart where one slice is separated from the rest of the pie.

Pie of Pie: Two connected pie charts, one displaying detailed data.

Bar of Pie: A pie chart connected to a bar chart.

Pie in 3-D: A three-dimensional pie chart.

Exploded Pie in 3-D: A 3D pie chart with one slice exploded.

For this tutorial, we will focus on how to create a Pie of Pie chart in Excel and how to use it for effective data analysis.

How to Create a Pie of Pie Chart in Excel

Here are the steps given below for your reference to create a Pie of Pie charts in Excel. create a pie of pie chart with two data sets in Excel:

Step 1: Open MS Excel in your device

Open an existing workbook in MS Excel or create a new one.

Step 2: In Excel, Click on the Insert tab

Click on the insert tab in in Excel

Step 3: Click on the Pie Chart option from lists of Charts

Click on the drop-down menu of the pie chart from the list of charts.

Step 4: Now, select Pie of Pie from that list

Select the pie of pie chart from the charts option in Insert toolbar.

Below are the Sales Data that were taken as a reference for creating Pie of Pie Chart:

The Pie Chart obtained for the above Sales Data is as shown below:

The pie of pie chart is displayed with connector lines, the first pie is the main chart, and to the right chart is the secondary chart.  The above chart does not display labels, i.e., the percentage of each product.  Hence, let's design and customize the pie of pie chart.

Design the Pie of Pie Chart in Excel

Follow the below steps to design a pie of pie chart,

• The design tab will be available by right-clicking on the chart. 
• Click on the Design tab to create labels and style the chart with different colors. We can choose any chart layout and style from the drop-down list of designs in Excel as shown in the figure below.

Here, we have chosen the first layout for our pie of pie chart as shown below:

How to Change the Data in the Secondary Pie

We can change the data that needs to be displayed in the secondary pie. To add data to the secondary pie from the first pie, right-click on the second pie and choose Format Data Series.

Here, the data series is split by percentage value, and also customized the second plot by having values less than 15%. In this way, a pie of pie chart can be customized in different ways. Now the pie of pie chart is formatted as follows:

Why Use Pie of Pie Charts in Excel

A Pie of Pie chart in Excel is especially useful for displaying small values in a dataset that might not be as visible in a regular pie chart. Here are some reasons why you should consider using it:

Better Clarity: Breaks down complex data into two pies, making it easier to understand smaller values.

Professional Reports: Useful for financial reports, sales data, or any business analysis requiring detailed breakdowns.

Customizable: You can split the data by percentage, position, or value, depending on what makes the most sense for your analysis.

How to Customize the Secondary Pie Chart

You can control what data is displayed in the secondary pie chart. Here’s how:

• Right-click on the Secondary Pie and select Format Data Series.
• You can adjust the percentage cutoff or select specific values to be displayed in the smaller pie.
• You can also change the colors and data labels to make the chart more visually appealing.

Additional Customization Options for Pie of Pie Charts

Apart from splitting data, Excel also allows you to further design your chart. You can:

Step 1: Change Chart Colors

Customize the colors of the pies to match your presentation style.

Step 2: Add a Chart Title

Provide a clear title that explains the data being displayed.

Step 3: Explode Slices

You can explode slices in both pies to emphasize particular data points.

How to Use Pie of Pie Charts for Data Analysis

Using a Pie of Pie chart is an excellent way to simplify complex datasets, particularly when analyzing data with many small values. It allows you to:

Showcase Smaller Categories: Highlight smaller categories or subcategories of your data.

Clearer Data Presentation: Avoid clutter in your charts by splitting the pie into two.

Better Reporting: Ideal for use in financial reports, marketing data, sales data, and other presentations.

Conclusion

Creating a Pie of Pie chart in Excel is a powerful way to display detailed breakdowns of your data in a clear and professional manner. By using this feature, you can visualize complex datasets more effectively, ensuring that even the smallest categories are visible. The pie of pie chart with two data sets allows for better data analysis, especially when you're dealing with many small values. Whether you’re preparing financial reports, sales analysis, or any other data presentation, mastering the Pie of Pie chart will make your data visualization more comprehensive and impactful. Try these steps today and elevate your data analysis skills in Excel.