How To Make A Pie Chart With Two Sets Of Data In Excel

excel logo

Pie charts are popular in Excel, but they are express. You'll have to make up one's mind for yourself betwixt using multiple pie charts or giving upwardly some flexibility in favor of readability by combining them. If you do want to combine them, here's how.

For example, the pie chart below shows the answers of people to a question.

A basic pie chart

This is fine, but information technology can exist complicated if you have multiple Pie charts.

Pie charts can only show one series of values. So if you have multiple series, and you lot want to present data with pie charts, you need multiple pie charts.

The image beneath shows the contribution to full revenues of v products across 3 unlike cities. Nosotros have a pie chart for each city with the data ranges shown to a higher place them.

Three pie charts

This enables us to compare the sales of products beyond unlike cities. But there are complications when we want to change them all consistently, or view them as a unmarried effigy.

In this article, we will wait at three different approaches to combine the pie charts.

Consolidate Data from Multiple Charts

The start approach looks at combining the data used by the pie charts.

It makes sense to show 1 pie chart instead of three. This would create more infinite on the report and mean less 'eye tennis' from the reader.

In this example, it volition come at the sacrifice of the metropolis comparison though.

The easiest and quickest mode to combine the data from the 3 pie charts is to use the Consolidate tool in Excel.

Let's consolidate the data shown below.

Consolidate data for a pie chart

Click a prison cell on the sheet where you the consolidated information to be placed. Click Data > Consolidate on the Ribbon.

The Consolidate window opens.

The Consolidate tool window

Nosotros'll apply the Sum office to total the sales from all three cities.

Next, nosotros have to gather all of the references which we want to consolidate. Click in the "Reference" box, select the start range, and and so click "Add together."

Echo this step for the other references.

Gathering the references to consolidate

Bank check the "Left column" box every bit the name of the production is to the left of the values in our data. Click "OK."

The Consolidate tool in Excel

We now accept a consolidated range from which to create our pie nautical chart.

This pie nautical chart makes information technology easier to see the contribution of each product type to the total revenue, but nosotros lose the comparison between each city that we had with three different charts.

Pie chart of the combined data

Combine Pie Nautical chart into a Unmarried Figure

Another reason that you may want to combine the pie charts is and so that you can move and resize them every bit one.

Click on the first nautical chart then hold the Ctrl key every bit y'all click on each of the other charts to select them all.

Click Format > Group > Group.

Group button on the Format tab

All pie charts are now combined equally ane figure. They will move and resize as one prototype.

Resizing pie charts as one

Choose Different Charts to View your Data

Although this article is almost combining pie charts, another option would exist to opt for a dissimilar chart type. Pie charts are not the only way to visualize parts of a whole.

A good alternative would be the stacked column nautical chart.

Take the example information below. This is the data used in this article simply now combined into i tabular array.

Data for the stacked column charts

Select the range of cells and click Insert > Cavalcade chart.

Insert column chart

There are two types of Stacked Cavalcade to choose from. The first one will present your data equally below.

Stacked column chart

This is like having iii pie charts in one chart.

Information technology does an splendid chore of both showing the contribution of values in each city, while also allowing us to compare the costs across cities.

For example, we can come across that Manchester produced the everyman acquirement and that sales of tea and fruit were depression compared to the other stores.

The 2nd Stacked Cavalcade chart option would present your information as below.

Comparing sales with the stacked percentage column

This uses a percentage in the centrality.

And then we lose the power to run across that Manchester produced the lowest acquirement, but it can give united states of america a better focus on the relative contribution. For example, almost of the sales from the Manchester store were from biscuits.

Y'all tin can click the "Switch Row/Column" button on the Design tab to switch the data between the axis and the legend.

Row and column data reversed in a stacked column

Depending on your reasons, there are unlike ways to combine pie charts into a single figure. This article explored three techniques as solutions to three dissimilar presentation scenarios.