How to Combine or Group Pie Charts in Microsoft Excel


excel logo

Pie charts are popular in Excel, but they are limited. You’ll have to decide for yourself between using multiple pie charts or giving up 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 it can be complicated if you have multiple Pie charts.

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

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

Three pie charts

This enables us to compare the sales of products across different cities. But there are complications when we want to change them all consistently, or view them as a single figure.

Read the remaining 45 paragraphs

Source: https://www.howtogeek.com/416048/how-to-combine-or-group-pie-charts-in-microsoft-excel/
Proactive Computing found this story and shared it with you.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.