Course / Charts

Pie charts, and when not to use one

Show a budget as shares of a whole, then see why a bar chart often says it better. Beginner · 4 min · Pie chart, Percentages, Choosing a chart

A pie chart shows one whole cut into its parts. It answers one question well: how big a share is this?

It only works when the parts add up to something meaningful (a budget, a market, a day), when there are few of them, and when none is negative.

It works badly for comparing parts with each other. People judge lengths far better than angles, so two similar slices are hard to tell apart. You'll see that for yourself in the last step.

Steps

  1. Here is a month's budget. Select A1:B6, click Chart, choose Pie, and click Insert.

  2. A pie is about shares, so let it say them. Tick Data labels in the Chart panel.

  3. Under Chart title, type Where the money goes.

  4. Now a harder question: which is bigger, Fun or Transport? On the pie, it is hard to say. Switch the chart to Bar in the Chart panel and look again.

Remember

Previous: Line charts for trends · Next: Scatter charts for relationships