Pie Charts
A pie chart works only when the values are parts of one whole, every value is positive, and there are about five slices or fewer. Beyond that the format fights the reader, because people judge angles poorly: few can tell a 22% slice from a 26% one without reading the label, and once they are reading labels a sorted bar chart delivers the same information faster and with room for long category names. Excel will happily draw a pie from anything you select, negative numbers included, plotting them as though they were positive with no warning at all — so a pie of profit by region where one region lost money is simply false. Keep pies for a genuine composition with a few large, clearly different slices, such as a budget split four ways, and move to Insert > Column or Bar the moment a sixth category appears.
A worked example
A2:A8 holds seven expense categories and B2:B8 the monthly spend: Rent 4,200; Payroll 3,900; Software 1,150; Marketing 980; Travel 640; Utilities 610; Supplies 520 — 12,000 in total.
Select A1:B8, Insert > Pie, then Chart Design > Add Chart Element > Data Labels > More Options and tick Percentage.
The two dominant slices, Rent at 35% and Payroll at 32.5%, are nine degrees of arc apart, which is close enough that most readers cannot say which is larger until they read the labels. The other five (9.6%, 8.2%, 5.3%, 5.1% and 4.3%) become a fringe of near-identical wedges. The same seven numbers sorted descending as a bar chart rank correctly at a glance, which is why a bar chart is the better default here. If the pie has to stay, Insert > Pie > Bar of Pie moves that small tail into a secondary stacked bar so the minor categories stop competing for the same few degrees.
Which one do I need?
| If you want to… | Use |
|---|---|
| The values are parts of one total, all positive, and there are five or fewer | A pie chart — this is the narrow case where it genuinely is the right answer |
| There are more than about six categories, or several are small and similar in size | A bar chart with the categories sorted descending; if a pie is non-negotiable, Bar of Pie or Pie of Pie splits off the tail |
| Any value in the range is negative | Not a pie: Excel plots the absolute value and the chart becomes untrue. A bar chart draws negatives below or left of zero, where they belong |
| You are comparing the composition of several wholes against each other | One 100% stacked bar per whole, which shares a baseline and lets the eye compare directly, instead of a row of pies |
| The composition changes over time | A stacked area or 100% stacked column chart across the periods — a pie can only ever show one moment |
| You want the slices labelled with percentages rather than raw values | Format Data Labels > tick Percentage. Excel derives each share from the plotted total, so no helper column is needed and the labels follow any edit to the data |
| You want a single slice pulled out for emphasis | Click the pie once to select the series, click that one slice again to select it alone, then drag it outward — dragging while the whole series is selected explodes every slice at once |
| The first slice should start somewhere other than the top | Format Data Series > Angle of first slice. Rotating changes nothing about the data, only which slice the eye lands on first |
| You need the middle of the circle free for a total or a KPI figure | A doughnut chart, which is a pie with the centre removed and exactly the same readability limits |
| Each slice needs to break down into sub-categories | A sunburst chart, which handles a real hierarchy; a nested doughnut only looks as though it does, because its rings are not tied to each other |
Frequently asked questions
Is a pie chart ever actually the right choice?
Yes, in a narrow case: a few positive values that are unambiguously parts of one whole, where the shares differ enough to be told apart by eye and the reader needs "roughly a third" rather than a precise ranking. Four regions splitting a budget qualifies. Twelve products splitting revenue does not, and neither does anything the reader is meant to rank precisely.
How many slices is too many for a pie chart?
Past about five the chart stops working, because the smaller wedges converge on the same handful of degrees and can no longer be distinguished or labelled without clutter. The usual fix is to keep the top four or five categories and total everything else into a single "Other" slice, or to switch to a sorted bar chart, which has no practical limit on the number of categories.
Why does my pie chart look wrong with negative numbers?
Because a circle has no way to represent less than nothing. Excel takes the absolute value of any negative and draws it as a positive slice, so a loss of 2,000 occupies the same wedge a profit of 2,000 would, and the percentages calculated against the total are meaningless. Nothing in the interface flags this. Use a bar chart, which places negative values on the other side of the zero line.
How do I show percentages on an Excel pie chart?
Select the chart, then Chart Design > Add Chart Element > Data Labels > More Data Label Options, and tick Percentage in the Label Options pane. Untick Value if you want the shares alone. Excel calculates each percentage from the sum of the plotted series, so the labels update themselves whenever the source data changes and never need a helper column.
New guides and tools, once a month
DE + EN · double opt-in · no spam