How to Make Two Pie Charts with One Legend in Excel

Get FREE Advanced Excel Exercises with Solutions!

If you are looking for how to make two pie charts with one legend in Excel, then you are in the right place. In our practical life, we often need to make pie charts for statistical analysis or research. Legends are very important to indicate different portions of the chart. Usage of diversified legends makes our charts more complex to understand. In this article, we’ll try to discuss how to make two pie charts with one legend in Excel.


Download Practice Workbook


2 Ways to Make Two Pie Charts with One Legend in Excel

We have limited methods to make two pie charts with one legend. To understand the methods, we have made a dataset named Amount of Products in Two Containers which has column headers as Name of product, Container 1 (kg), and Container 2 (kg) in Columns B, C, and D respectively. The dataset is like this.

how to make two pie charts with one legend in excel

Let’s discuss the two methods to make pie charts with one legend.


1. Merge Two Pie Charts with One Legend

When we need to merge two pie charts into one with one or the same legend we need to follow this method. We’ll try to include the amounts of products of Container 1 and Container 2 into one single pie chart with one legend. To do this,  we need to work on the following dataset of Merging Two Pie Charts with One Legend.

how to make two pie charts with one legend in excel, merging

The steps are like this.
Firstly, select the whole dataset > go to Insert tab> select symbol of pie charts > select More Pie Charts.

how to make two pie charts with one legend in excel, merging

Eventually, this Insert Chart window will appear.
Secondly, select as stated icons in the picture below and click OK.

how to make two pie charts with one legend in excel, merging

As a result, a chart like this will appear.

how to make two pie charts with one legend in excel, merging

Thirdly, right-click the inner circle of the chart > select Format Data Series.

how to make two pie charts with one legend in excel, mergingA Format Data Series window will appear.
Fourthly, change the Doughnut Hole Size to 0%.

how to make two pie charts with one legend in excel, merging

Consequently, the shape of the chart will be like this. Change the Chart Title to Merged Pie Chart.

how to make two pie charts with one legend in excel, merging

Fifthly, right-click on the upper outer circle of the chart > select Add Data Labels.

how to make two pie charts with one legend in excel, merging

The data in the dataset to different regions will be added according to their category.

how to make two pie charts with one legend in excel, merging

Sixthly, right-click on any of the data in the circle > select Format Data Labels.

how to make two pie charts with one legend in excel, merging

A Format Data Labels window will appear.
Seventhly, select Percentage and deselect Value. We can select any options here according to our requirements.

how to make two pie charts with one legend in excel, merging

Eventually, the amounts in different portions in the chart with percentages will be shown.

how to make two pie charts with one legend in excel, merging

Eighthly, repeat the same procedure for the inner circle of the chart too.
Ninthly, after getting the values in percentage in the inner portion, just click them and slide them out of the circle. Automatic lines joining the values with the circle will appear. We can do this for the lack of space in the inner chart.
Finally, we will get our chart like this.

how to make two pie charts with one legend in excel, merging

Eventually, we can change the color of the chart for better visual representation.
To do this, select the draw icon > select Color > choose any color options. We have selected the Green colored icon option.

how to make two pie charts with one legend in excel, merging

Lastly, we’ll get our chart like this.

how to make two pie charts with one legend in excel, merging

Read More: How to Format a Pie Chart in Excel


Similar Readings


2. Usage of PowerPoint to Make Two Pie Charts with One Legend in Excel

When we want to make two different pie charts with one legend we need to follow this procedure. In this procedure, we need the help of Microsoft PowerPoint.  We can apply this method in the following dataset Using PowerPoint.

how to make two pie charts with one legend in excel, using PowerPoint

Firstly, select columns B and C like the picture below > go to Insert > select pie chart symbol > go to 2-D Pie.

how to make two pie charts with one legend in excel, using PowerPoint

Eventually, a pie chart of Container 1 (kg) will appear.

how to make two pie charts with one legend in excel, using PowerPoint

Secondly, right-click on the chart > select Add Data Labels.

 using PowerPoint

Thirdly, following the steps of the previous method we need to select the Percentage and deselect the Value as we have done in the first method and after that our output is like this.

how to make two pie charts with one legend in excel, using PowerPoint

Similarly, we need to follow the same steps for Container 2 and we get the pie chart like this.

 using PowerPoint

Fourthly, open Microsoft PowerPoint.

 using PowerPoint

Fifthly, copy the pie chart of Container 1 (kg) from the Excel sheet by pressing CTRL+C.
Sixthly, click Paste on the PowerPoint > select the marked icon in the Paste Option.

using PowerPoint

Consequently, the two pie charts will be pasted into the PowerPoint. Level them like the picture below.

 using PowerPoint

Seventhly, copy the chart of Container 1 by pressing CTRL+C.
Eighthly, right-click the mouse > select the marked icon in the Paste Options.

how to make two pie charts with one legend in excel, using PowerPoint

A similar chart of Container 1 will appear.
Ninthly, select the legend on chart 1 and press DELETE. Also, delete the legend of chart 2.

how to make two pie charts with one legend in excel, using PowerPoint

Tenthly, level the three charts like the picture.

how to make two pie charts with one legend in excel, using PowerPoint

Eleventhly, right-click on any portion of the copied chart of Container 1 (it will select all the data) > select Edit Data.

how to make two pie charts with one legend in excel, using PowerPoint

Eventually, a Chart in Microsoft PowerPoint Excel sheet will open.
Twelfth, change all the values in Column C to 0.

how to make two pie charts with one legend in excel, using PowerPoint

As a result, the charts in the PowerPoint will look like this. The copied chart will disappear.

how to make two pie charts with one legend in excel, using PowerPoint

Now, stretch the copied chart on both the left and the right side by dragging the cursor like the picture below.

using PowerPoint

Consequently, it will look like this.

using PowerPoint

Later, select Format > click Shape Fill > select No Fill.

using PowerPoint

Similarly, go to Format > select Shape Outline > select No Outline.

using PowerPoint

As a result, two legends will change to one legend like this. We need to delete the unused title of Container 1 (kg) and other unused values located in the middle of the picture.

using PowerPoint

Finally, we’ll get our desired two pie charts with one legend like this.

using PowerPoint

Read More: How to Edit Legend of a Pie Chart in Excel (3 Easy Methods)


Things to Remember

  • One very important thing is, when we need to copy & paste charts from Excel sheet to PowerPoint in the second method, we have to select the marked paste option which we have described above. It will link the chart PowerPoint with the Excel Otherwise, no interlink will be created, and changing anything in Excel will not make a change in the PowerPoint.
  • We need to use the selected paste option when we just copy & paste the chart of Container 1 (kg) in the PowerPoint. If we just paste it by pressing CTRL+V, any change made in the Container 1 values in the Excel sheet will change both the main chart and copied chart of Container 1 in the PowerPoint.

Conclusion

We can make two pie charts with one legend in Excel easily if we study this article properly. Please feel free to visit our official Excel learning platform ExcelDemy if you have further queries.


Related Articles

Shajratul Alam Towhid
Shajratul Alam Towhid

Hello, myself Shajratul Alam Towhid. Basically, I am a Naval Architect who wants to expand knowledge in the field of Microsoft Excel. I wish all of my articles will be beneficial for the readers.

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo