قالب وردپرس درنا توس
Home / Tips and Tricks / Combining or grouping pie charts in Microsoft Excel

Combining or grouping pie charts in Microsoft Excel



  Excel Logo

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.

 A basic pie chart

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.

 Three Pie Charts

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 [19659012] 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.

 Consolidate the data for a pie chart into the consolidated data to place. On the Ribbon, click Data> Consolidate. </p>
<p>  The Consolidate window opens. </p>
<p>  <img class=

The Sum function sums sales for all three cities. [19659003] 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.

 Gathering References to Consolidate

Check the "Left Column" field as the name of the product is to the left of the values ​​in our data. Click OK".

 The Consolidation Tool in Excel

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.

 Pie chart of combined data

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.

 Group button on the Format tab

All pie charts are now combined into a single figure. They are moved as a picture and resized.

 Resizing Pie Charts as One

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.

 Data for the stacked column charts

Select the range of cells and click Insert> Column Chart.

 Insert Column Chart

There are two types of stacked columns to choose from. The first one displays your data as follows.

 Stacked Column Chart

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.

 Compare Sales to Stacked Percent Column

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.

 Inverted Row and Column Data in a Stacked Column

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.


Source link