To make a pie chart from percentages, enter each category with its percentage and check that they add up to 100%. Totals of 99–101% are normal rounding. If the total is lower, add an “Other” slice for the gap; if it is far above 100%, the data overlaps and needs a bar chart.
If a report already gives you percentages, you don’t need the original numbers. A pie chart only needs the proportions. The one rule is that the percentages must describe one whole and add up to about 100%.
Steps
- Open the pie chart from percentages tool. It starts in percentage mode.
- Type each category and its percentage. You can include or leave out the % sign.
- Watch the total under the table. If it reads 100%, you’re done.
- If the total is below 100%, click Add “Other” to fill the gap with an honest “Other” slice.
What if the percentages don’t add up to 100%?
- 99% or 101%: almost always rounding in the source. That’s fine to chart.
- Well under 100% (say 85%): some categories are missing. Add an “Other” or “Not stated” slice so the chart doesn’t exaggerate the slices you have.
- Well over 100% (say 140%): respondents could choose more than one answer. That data doesn’t belong in a pie chart. Use a bar chart instead.
Frequently asked questions
Do I need the original numbers to make a pie chart?
No. Percentages are enough, because a pie chart only shows proportions.
What happens if my percentages add up to less than 100%?
The chart stretches the slices to fill the circle, so each one looks bigger than it is. Add an “Other” slice for the missing share.