How To Make A Pie Chart In Excel With Multiple Data

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

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

This is fine, but it can be complicated if you have multiple Pie charts.

Pie charts can but show ane series of values. And so if you have multiple series, and y'all want to present data with pie charts, yous need multiple pie charts.

The image beneath shows the contribution to total revenues of 5 products across three different cities. Nosotros have a pie chart for each city with the data ranges shown above them.

This enables united states of america to compare the sales of products across different cities. Just there are complications when we want to alter them all consistently, or view them as a single effigy.

In this commodity, we will look at iii unlike approaches to combine the pie charts.

Consolidate Information from Multiple Charts

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

It makes sense to testify one pie nautical chart instead of 3. This would create more than space on the report and mean less 'center tennis' from the reader.

In this example, information technology will come at the sacrifice of the urban center comparison though.

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

Let's consolidate the information shown below.

Click a cell on the sheet where you lot the consolidated data to exist placed. Click Information > Consolidate on the Ribbon.

The Consolidate window opens.

We'll employ the Sum function to full the sales from all three cities.

Next, we take to gather all of the references which nosotros desire to consolidate. Click in the "Reference" box, select the first range, and then click "Add together."

Repeat this step for the other references.

Cheque the "Left column" box equally the proper noun of the product is to the left of the values in our data. Click "OK."

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

This pie chart makes it easier to meet the contribution of each product type to the total revenue, but nosotros lose the comparing between each city that we had with three different charts.

Combine Pie Chart into a Single Figure

Another reason that you may want to combine the pie charts is and so that y'all can move and resize them as 1.

Click on the showtime chart and so concord the Ctrl key equally you click on each of the other charts to select them all.

Click Format > Group > Group.

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

Choose Different Charts to View your Data

Although this article is about combining pie charts, some other choice would exist to opt for a different chart blazon. Pie charts are not the merely manner to visualize parts of a whole.

A good culling would be the stacked column chart.

Take the example information below. This is the data used in this article but at present combined into one table.

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

There are two types of Stacked Cavalcade to choose from. The start 1 will present your information as below.

This is like having three pie charts in one chart.

It does an excellent job of both showing the contribution of values in each city, while also allowing us to compare the costs across cities.

For instance, we can run across that Manchester produced the everyman revenue and that sales of tea and fruit were low compared to the other stores.

The second Stacked Column chart option would present your data every bit beneath.

This uses a per centum in the axis.

So we lose the ability to come across that Manchester produced the everyman revenue, but information technology can give us a better focus on the relative contribution. For case, most of the sales from the Manchester store were from biscuits.

You can click the "Switch Row/Column" button on the Design tab to switch the information betwixt the axis and the fable.

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 different presentation scenarios.

How To Make A Pie Chart In Excel With Multiple Data,

Source: https://www.howtogeek.com/416048/how-to-combine-or-group-pie-charts-in-microsoft-excel/

Posted by: hadlockemenceapery2002.blogspot.com

Share this post