0

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


Post a Comment Blogger

We welcome comments that add value to the discussion. We attempt to block comments that use offensive language or appear to be spam, and our editors frequently review the comments to ensure they are appropriate. As the comments are written and submitted by visitors of The Sheen Blog, they in no way represent the opinion of The Sheen Blog. Let's work together to keep the conversation civil.

 
Top