How to Calculate Pie Chart Percentages

The formula, a fully worked example, and how to handle rounding so your pie chart percentages add up to exactly 100%.

By the PieChartTool team · Updated · 5 min read

Quick answer

To calculate a pie chart percentage, divide each slice’s value by the total of all values and multiply by 100. Example: 84 out of a total of 240 is 84 ÷ 240 × 100 = 35%. The percentages of all slices should add up to 100%.

Each slice’s percentage comes from one simple formula:

Percentage = (slice value ÷ total of all values) × 100

Worked example

A small bakery sold these items on Saturday:

ItemUnits soldCalculationPercentage
Bread8484 ÷ 240 × 10035%
Muffins6060 ÷ 240 × 10025%
Cookies5454 ÷ 240 × 10022.5%
Pies4242 ÷ 240 × 10017.5%
Total240100%
  1. Add up all the values: 84 + 60 + 54 + 42 = 240.
  2. Divide each value by 240.
  3. Multiply by 100 to turn the fraction into a percentage.
  4. Check that the percentages add up to 100.
The bakery data with percentage labels (shown to one decimal place).

Why rounded percentages sometimes add up to 99% or 101%

Say three slices are each one third: 33.33…%. Round each to a whole number and you get 33% + 33% + 33% = 99%. Nothing is wrong with the data. Each number just lost a little in rounding.

The usual fix is the largest remainder method. Round everything down, then add 1 to the slices with the biggest leftover fractions until the total is 100. Our pie chart maker does this automatically when Round to exactly 100% is on. The thirds become 34% + 33% + 33%.

In a spreadsheet

If your values are in B2:B5, put this in C2 and fill it down, then format column C as Percent:

=B2/SUM($B$2:$B$5)

Prefer not to do it by hand? Paste your numbers into the pie chart calculator to get every percentage and angle at once.

Frequently asked questions

Why do my pie chart percentages add up to 99% or 101%?

Because each percentage was rounded separately. The largest remainder method fixes this by rounding down, then adding 1 to the slices with the largest leftover fractions until the total is exactly 100.

What is the Excel formula for pie chart percentages?

With values in B2:B5, use =B2/SUM($B$2:$B$5) and format the cell as a percentage.