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
Here is a month's budget. Select
A1:B6, click Chart, choose Pie, and click Insert.A pie is about shares, so let it say them. Tick Data labels in the Chart panel.
Under Chart title, type Where the money goes.
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
- A pie shows the parts of one whole. Keep it to a few slices.
- Its data labels are percentages.
- To compare the parts with each other, bars are clearer than slices.
- Changing the chart type redraws the same data; nothing is lost.
Previous: Line charts for trends · Next: Scatter charts for relationships