Pie charts are very popular in Excel, but only to a limited extent. You have to decide for yourself if you want to use multiple pie charts or give up flexibility for legibility by combining them. If you want to combine them, do the following:
For example, the following pie chart shows people's answers to a question.
That's fine. However, with multiple pie charts, this can be complicated.
Pie charts can only display a series of values. So if you have multiple series and want to plot data in pie charts, you will need multiple pie charts.
The following figure shows the contribution to total sales of five products in three different cities. We have a pie chart for each city with the data areas displayed above it.
This way we can compare the sales of products across different cities. However, there are complications if you want to change them consistently or display them as a single number.
This article presents three different approaches to combining the pie charts.
Consolidate data from multiple charts  The first approach is to combine the data used by the pie charts.
It makes sense to display a pie chart instead of three. This would create more space in the report and mean less "eye tennis" for the reader.
In this example, however, it will be the victim of city comparison.
The Easiest and Fastest Way to Combine Data From the three pie charts, you can use the consolidation tool in Excel.
Consolidate the data shown below.
The Sum function sums sales for all three cities.  Next, we need to gather all the references we want to consolidate. Click in the Reference box, select the first panel, and then click Add.
Repeat this step for the other references.
Check the "Left Column" field as the name of the product is to the left of the values in our data. Click OK".
We now have a consolidated section for creating our pie chart.
This pie chart makes it easy to see the contribution of each product type to total sales, but we lose the comparison between each city we had with three different charts.
Combine pie chart into a single figure
Another You may want to combine pie charts to move and resize them.
Click on the first graph and hold down the Ctrl key while clicking on each of the other graphs to select them all.
Click Format> Group> Group.
All pie charts are now combined into a single figure. They are moved as a picture and resized.
Selecting Various Charts to Display Your Data
Although this article discusses how to combine pie charts, another option is to choose a different chart type. Pie charts are not the only way to visualize parts of a whole.
A good alternative would be the stacked column chart.
Take the following sample data. These are the data used in this article, which are now summarized in a table.
Select the range of cells and click Insert> Column Chart.
There are two types of stacked columns to choose from. The first one displays your data as follows.
This is equivalent to three pie charts in one chart. We can see, for example, that Manchester had the lowest revenue and that the sale of tea and fruit was low compared to the other stores.
The second option for a stacked column chart represents your data as follows.
This uses a percentage in the axis.
So we lose the ability to see this Manchester has the lowest revenue, but can give us a better focus on the relative contribution. For example, most of the Manchester store sales came from biscuits.
You can click the Switch Row / Column button on the Design tab to switch data between Axis and Legend.
Depending on your reasons, there are several ways to combine pie charts into a single figure. In this article, three techniques were explored as a solution to three different presentation scenarios.