Pie Chart Formula for Percentages and Angles

The key pie-chart formulas are straightforward: a slice’s share is its category value divided by the total of all category values; its percentage is that share multiplied by 100; and its central angle is that share multiplied by 360°. In Excel, the chart can calculate the slice proportions from the values, while formulas help you check or display the percentages and angles.

What the Pie Chart Formula Means

A pie chart represents a complete total as a circle. Each category gets a slice whose size is proportional to its part of that total. To find a category’s share, divide its value by the sum of all category values. Multiply the share by 100 to express it as a percentage, or by 360 degrees to find the angle of the slice.

For example, if a category accounts for one quarter of the total, it represents 25% of the circle and has a 90-degree angle. The relationship works in reverse too: divide a slice angle by 360 to recover its share. These calculations describe the same proportion in different forms; a percentage is often easiest for readers to understand, while an angle is useful when drawing a pie chart by hand.

The denominator matters. It must represent the complete set of categories shown in the chart, measured on a consistent basis. If you chart monthly expenses, for instance, use amounts from the same month and the same currency. The values need not already be percentages: counts, quantities, or amounts can all work, provided that the slices genuinely add up to a meaningful whole.

A Worked Example: Values, Percentages, and Angles

Suppose a shop records 30 apples, 20 bananas, 10 cherries, and 40 grapes sold. The total is 100 items. Apples therefore make up 30% of sales and occupy 108 degrees of the circle. Bananas account for 20% and 72 degrees; cherries, 10% and 36 degrees; and grapes, 40% and 144 degrees.

Check the results before using them: the percentages total 100%, and the angles total 360°. That check is useful because a small arithmetic or data-entry error can otherwise lead to a chart that appears plausible but does not match the source figures. Here is the same example in an Excel worksheet:

Enter the category names in A2:A5: Apples, Bananas, Cherries, and Grapes.
Enter the corresponding values in B2:B5: 30, 20, 10, and 40.
Use B6 for the total, C2:C5 for percentages, and D2:D5 for angles.

With values in B2:B5 and the total intended for B6, enter this in B6. It returns 100:

=SUM(B2:B5)

With category values in B2:B5 and their total in B6, enter this in C2 to calculate the first category’s share. It returns 0.3, which displays as 30% when the cell is formatted as a percentage:

=B2/$B$6

With the same layout, enter this in D2 to calculate the first slice’s angle. It returns 108:

=B2/$B$6*360

Copy the C2 and D2 formulas down through row 5. The dollar signs keep the total reference fixed while the category reference changes from row to row. To show C2:C5 as percentages in Excel for Microsoft 365 on Windows, select those cells and choose Home > Number > Percent Style. Excel for Mac has the same basic number-formatting control on the Home tab.

Making a Pie Chart in Excel

Excel does not require you to calculate percentages or angles before creating a pie chart. It uses the values to determine each slice’s relative size. To create the example chart in Excel for Microsoft 365 on Windows, select A1:B5 if you have headers in row 1, then choose Insert > Insert Pie or Doughnut Chart > 2-D Pie. If your data has no headers, select A2:B5 instead. Include the labels as well as the values so the chart can identify each slice.

To display percentages on the chart, select the chart and choose Chart Design > Add Chart Element > Data Labels > More Data Label Options. In the Format Data Labels pane, select Percentage and, if useful, Category Name. You can clear Value if you want percentages without the original counts. Excel for Mac offers the corresponding pie-chart and data-label features from its Insert and chart-design controls; exact ribbon wording can vary slightly by version.

Check the finished chart against the data. Make sure the labels match the intended categories, that the chart contains the right values, and that the displayed percentages are understandable. If you label the slices with both percentages and raw counts, use consistent formatting and avoid crowding. A legend can identify categories, but direct labels are often easier to follow when there are only a few slices.

When a Pie Chart Is a Good Choice

A pie chart is most useful when the purpose is to show how a small number of categories divide one whole. The categories should be distinct rather than overlapping, and the values should use the same unit and time period. A pie chart can communicate that one category is a large share or that several categories contribute small shares without requiring readers to inspect a table.

Before choosing one, ask whether the data really represents a whole. A breakdown of one year’s budget by spending category may fit. A chart of the number of website visits in January, February, and March does not automatically show parts of one whole if the point is to compare month-to-month activity; a column chart will usually make that comparison clearer. The choice depends on the question, not just on whether the data can be added.

Keep the number of slices manageable. There is no universal slice-count cutoff, but many narrow categories or similar-sized values make a pie harder to read. If some small categories are important, consider showing their values in a table or grouping them only when that grouping is meaningful and clearly labeled. Do not combine unrelated items into an unexplained category merely to simplify the picture.

Common Formula and Data Problems

A frequent misconception is that every category must be converted to a percentage before it can be charted. For an ordinary pie chart, Excel accepts the original values and calculates their relative proportions. Pre-calculating percentages is optional and may be helpful for auditing or labels, but it is not necessary to create the chart.

Other problems are about what the data means, rather than the arithmetic:

Negative values: A negative quantity cannot be represented as a positive portion of a whole in a standard pie chart. Investigate the data or choose a chart type suited to the comparison.
A zero total: If all values are zero, there is no meaningful whole to divide into slices.
Overlapping categories: If the same item can be counted in more than one category, adding the categories may double-count items. A pie can still normalize the values to the total, but the result may not represent parts of a whole.
Rounded labels: Percentages rounded to whole numbers may add to 99% or 101% even when the underlying values total exactly 100%. This is a rounding effect; use more decimal places or explain the rounding if exact totals matter.
Too many small slices: Similar colors and cramped labels make comparisons difficult. Consider a bar chart or a table instead.

One especially important case is a multiple-response survey. If respondents can select several answers, the number of selections can exceed the number of people surveyed. A pie chart of those counts may imply a single complete whole when the answers overlap. A bar chart is usually a more honest way to compare how often each answer was chosen.

Pie Charts Compared with Other Charts

A bar or column chart is usually better when readers need to compare values precisely, especially when categories are close in size. People can compare bar lengths against a common scale more readily than they can judge small differences between slice angles. Bars also accommodate more categories and longer labels without forcing a crowded circle.

A doughnut chart uses the same part-to-whole logic as a pie chart but leaves a hole in the center. It can be styled differently or used to place a total in the middle, but the hole does not make slice comparisons more precise. A 100% stacked bar chart can show proportions across several groups, such as the makeup of expenses in multiple years; a single pie chart is designed for one set of parts, not a straightforward comparison of multiple totals.

Use a pie chart when the whole is central to the message and the categories are few enough to identify clearly. Choose another chart when the main task is ranking categories, comparing changes over time, showing overlapping responses, or displaying precise differences.

Frequently Asked Questions

What is the formula for the percentage in a pie chart?

Divide a category’s value by the sum of all category values, then multiply by 100 to express the result as a percentage. In Excel, you can calculate the share as a decimal and format the cell as a percentage.

How do you calculate a pie-chart angle?

Divide the category value by the total, then multiply that share by 360 degrees. A category that is 25% of the total has a 90-degree slice.

Do I need to calculate percentages before making a pie chart in Excel?

No. Select the category labels and original values, then insert a pie chart. Excel calculates each slice’s proportion; you can add percentage data labels afterward if readers need them.

Why do my pie-chart percentages not add to 100%?

The underlying shares may add to 100%, but rounded labels can appear to total 99% or 101%. Also check whether the chart includes all intended categories and whether any categories overlap.

Can a pie chart show negative values?

A standard pie chart is not suitable for negative values because a negative amount cannot represent a positive slice of a whole. Check the data or select a chart that can communicate positive and negative comparisons clearly.

Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.

More in Charts & pivot tables

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.