The most important thing you have to keep in mind is that a pie chart always represents a whole, i.e. The more numerical columns you upload, the more pies your chart will have. In your final chart, one numerical column will result in one extra pie. The values in the columns will define the size of the pie slices.

At least one column containing numeric values.

In our case, the three categories are: 'bottom 50%', 'next 40%' and 'top 10%''

One column containing at least two categories. This will determine the label in the pie slices.

One header row containing descriptive labels.

If you want to create this chart type, here's what you'll need: We can see the shares of three countries' wealth that the bottom 50%, the next 40% and the top 10% of citizens own:

If you want to show more than five parts per pie, consider grouping them as a stacked bar chart.īelow is an example of a multiple pies chart that makes good use of the part of the whole concept. The individual pies should not have too many slices as this clutters the chart and makes it hard to read.

A multiple pies chart is useful when you want to show proportional parts of multiple wholes and to give the reader an extra data point in the middle.

Create pie chart in excel two columns