Pie Chart From Percentages
Enter percentages directly. We check that they add up to 100%.
Data
Number format
Try sample data
Demo data only. It replaces your rows and keeps your design.
Your percentages add up to 92%, not 100%. The chart scales the slices to fill the circle, so each slice looks bigger than its number. Add a slice for the missing 8% to fix this.
Design
The classic. Best for 2–7 parts of a whole.
To make a pie chart from percentages, enter each category with its percentage and make sure the total is 100%. A total of 99–101% is normal rounding. If the total is lower, add an “Other” slice for the missing share. Otherwise the chart stretches every slice and exaggerates it.
Try it: these percentages add up to 92%
The sample data above is missing 8%. Look under the data table and the chart: the tool explains the problem and offers to Add “Other” (8%). Without that slice, the chart would stretch the four slices to fill the circle, and each would look about 9% bigger than it really is.
How percentage mode works
- Type numbers with or without the % sign, like
42or42%. - The total under the table shows the sum of your percentages.
- Totals between 99.5% and 100.5% are treated as rounding and accepted as they are.
- Totals below that trigger a warning and a one-click fix. Totals above it trigger a warning to check for overlapping categories.
Percentages that add up to more than 100%
That usually comes from “select all that apply” questions, where one person can be counted in several categories. Those numbers aren’t parts of one whole, so a pie chart is the wrong tool. Switch to a bar chart under Chart type instead. Read more in how to make a pie chart from percentages.
Have raw numbers instead?
Switch Values are back to Numbers and type your raw counts or amounts. The percentages are calculated for you. The pie chart calculator also shows the exact math.
Percentage pie chart FAQ
Can I enter percentages instead of numbers?
Yes. Set “Values are” to Percentages and type each share, with or without the % sign. The tool checks that the total is 100%.
What if my percentages don’t add up to 100?
Totals between 99.5% and 100.5% are treated as rounding. If the total is lower, click Add “Other” to fill the gap. If it is far above 100%, categories overlap and a bar chart is the better choice.