The pie chart angle formula is slice angle = (category value ÷ total of all values) × 360°. Divide a category’s value by the overall total to find its share, then multiply that share by 360 because a complete circle contains 360 degrees.
For example, if a category accounts for 24 out of 60 items, its slice measures (24 ÷ 60) × 360° = 144°. The same calculation works for counts, percentages, money amounts, or other nonnegative values, as long as the values represent parts of one meaningful whole.
The Pie Chart Angle Formula
For a category with value v and a total T, write the formula as:
Angle in degrees = (v ÷ T) × 360°
The fraction v ÷ T is the category’s proportion of the total. Multiplication by 360° converts that proportion into the matching portion of the circle. If the category has 12 units out of 48, for instance, its share is 12 ÷ 48 = 0.25, or one quarter. One quarter of 360° is 90°.
The formula can also be written using a percentage: angle = percentage × 3.6°. This works because 100% corresponds to 360°, so each percentage point corresponds to 3.6°. A category at 15% therefore occupies 15 × 3.6° = 54°.
Why the Formula Uses 360 Degrees
A pie chart represents data using a full circle. A full turn is 360°, so a category’s angle must match its fraction of that turn. A category that is half the total gets half of the circle, or 180°; one that is a tenth gets 36°. The geometry is the same whether the slice is calculated from a survey count or a budget amount.
When the category values are added together, their shares add to 1, or 100%. Their angles must therefore add to 360°. This is a useful check: if carefully calculated angles total substantially more or less than 360°, the data, arithmetic, or rounding needs review. The angles are central angles, measured from the center of the chart between the two radii that form a slice.
Worked Example With Counts
Suppose a small survey records people’s preferred fruit: 24 choose apples, 18 choose bananas, 12 choose oranges, and 6 choose pears. First add the category values: 24 + 18 + 12 + 6 = 60 responses. Then calculate each category’s fraction of 60 and multiply by 360°.
- Apples: (24 ÷ 60) × 360° = 144°.
- Bananas: (18 ÷ 60) × 360° = 108°.
- Oranges: (12 ÷ 60) × 360° = 72°.
- Pears: (6 ÷ 60) × 360° = 36°.
Check the result: 144° + 108° + 72° + 36° = 360°. The matching percentages are 40%, 30%, 20%, and 10%, which also total 100%. The largest category has the largest angle, and the 10% pear category occupies one tenth of the circle.
Calculating Angles From Percentages
If the data is already expressed as percentages, you do not need to find the original total. Multiply each percentage by 3.6°. For example, 7% corresponds to 7 × 3.6° = 25.2°, while 32.5% corresponds to 32.5 × 3.6° = 117°. A percentage can produce a decimal angle; there is no mathematical requirement that every slice be a whole number of degrees.
First check how the percentages were produced. If they are rounded values, they may add to 99.9% or 100.1% rather than exactly 100%. Applying the formula to those displayed values can produce a small mismatch in the total angle. When possible, calculate angles from the original counts or unrounded proportions, and use rounded percentages only for presentation.
For percentages that do sum to 100%, a useful check is to add the calculated angles. For example, 40% × 3.6° = 144° and 60% × 3.6° = 216°; together they make 360°.
Rounding Angles Without Breaking the Circle
Exact angles often include decimal places, but a hand-drawn chart or a set of whole-degree labels may call for rounding. Round only after calculating each angle from the original values. Rounding early, such as rounding each category’s percentage before converting it, can add avoidable error.
Independently rounded angles do not always add to 360°. Imagine many categories whose exact angles each end in a fraction of a degree. Rounding every slice to the nearest whole degree can make the displayed total 359° or 361°. That small difference is a rounding effect, not proof that the basic formula is wrong.
If whole-degree values must total exactly 360°, use a consistent allocation method. One practical approach is to round the calculated angles, add them, and adjust the slice with the largest fractional remainder by the small difference needed to reach 360°. For a chart made with software, retain the exact values and let the program draw the slices; round only the labels if needed. Do not silently change a value by several degrees just to force a total.
Choose Data That Represents One Whole
A pie chart is appropriate only when its categories are parts of a single total. The categories should be mutually exclusive, so an observation is counted in one slice rather than several, and collectively exhaustive if the chart is meant to show the entire population. For example, a chart of one person’s choice among four mutually exclusive options can form a whole. A chart that counts people who selected multiple options may double-count respondents and no longer describe distinct pieces of one whole.
Use values that can meaningfully be added. Counts, proportions, and nonnegative amounts are common examples. A category’s value cannot be converted into a sensible pie angle if the total is zero, since division by zero is undefined. Negative values also do not represent ordinary portions of a whole circle. If categories include negative and positive amounts, choose a different visualization rather than applying the formula mechanically.
Check for missing categories and duplicate records before calculating. If a report leaves out an unclassified group, the slices may represent only the recorded subset, not the population readers assume they represent. State the denominator or scope clearly, such as responses received, units sold, or total spending in a particular period.
Calculate Angles in Excel
In Microsoft Excel for Microsoft 365 on Windows, place the category values in cells A2:A5 and enter the angle formula in B2. With 24, 18, 12, and 6 in A2:A5, the total is 60 and the formula is =A2/SUM($A$2:$A$5)*360. It returns 144 for the first category. Copy the formula down through B5 to calculate the other angles; the locked total range stays A2:A5 while the category reference changes by row.
The results are degrees as ordinary numbers; the formula does not add a degree symbol. You can label the column Angle (degrees), or format the displayed values separately. To check the total, with the four angle results in B2:B5, use =SUM(B2:B5); the worked example returns 360. If you want to create the chart itself, select the category names and their original values and insert a pie chart. The charting software calculates slice proportions from the data, so manually entered angles are mainly useful for understanding, checking, or drawing a chart by hand.
How to Draw a Pie Chart by Hand
Once you have the angles, use a protractor to mark each central angle from the circle’s center. Draw a starting radius, measure the first angle from it, and draw the next radius. Continue from the new boundary for each following slice. The final boundary should meet the starting radius after the complete 360° turn.
- Find the total and calculate every category’s angle.
- Draw a circle and mark its center.
- Draw a starting radius and measure the first slice with a protractor.
- Use each new boundary as the starting line for the next angle.
- Label slices and compare the final layout with the expected 360° total.
For a hand-drawn chart, start with a larger or easier-to-measure slice when convenient, but keep the underlying order and measurements consistent. Add category names or a legend, and include the total or percentage basis so the chart can be interpreted without guessing.
Pie Charts Compared With Other Displays
A pie chart emphasizes how categories contribute to one whole. It is most readable when there are only a few categories and the differences are substantial. With many thin slices, close values, or long labels, readers may struggle to compare angles accurately. A bar chart is often clearer for comparing category sizes, particularly when values are close together or there are numerous categories.
A pie chart also makes comparisons across separate groups or time periods awkward: readers must compare angles in different circles. A bar chart, or a stacked bar chart when showing composition is important, can make those comparisons more direct. The angle formula can still be calculated correctly even when a pie chart is not the clearest choice; the formula does not determine whether the chart type suits the question.
Frequently Asked Questions
How do you calculate the angle of a pie chart slice?
Divide the category value by the sum of all category values, then multiply by 360°. For a value of 20 out of a total of 80, the angle is (20 ÷ 80) × 360° = 90°.
What is the formula for a pie chart angle in percentage?
Multiply the percentage by 3.6°. For example, a 25% slice measures 25 × 3.6° = 90°. This conversion assumes the percentage is expressed on a 0-to-100 scale.
How do you find the total if the angle is known?
The angle gives the category’s share, not the overall count by itself. If the category value and angle are known, total = category value × 360° ÷ angle. For example, 12 items represented by 72° imply a total of 12 × 360 ÷ 72 = 60 items.
Do pie chart angles have to add up to 360°?
Yes, the exact angles for a complete pie chart add to 360°. Rounded labels may total slightly above or below 360°, so use unrounded calculations for the chart and treat small differences as rounding.
Can a pie chart include zero or negative values?
A zero value has a zero-degree slice and may not be visible. Negative values cannot represent ordinary parts of a whole circle, and a zero total makes the formula undefined. For negative or mixed-sign data, use another chart type.
Related
- Excel Trendlines with Dates: How to Make Them Work
- Excel Text to Columns Shortcut Key for Windows and Mac
- Excel Text to Columns Using Enter: Split Line Breaks
Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.
More in Charts & pivot tables
- Power Pivot: Merge Two Tables or Create a Relationship?Power Pivot does not have a Power Query-style Merge command: to combine tables into one query, use Data…
- Power Pivot Hierarchy: Create and Use One in ExcelA Power Pivot hierarchy is an ordered set of related columns from one table in Excel’s Data Model,…
- Google Sheets Pivot Table Auto Refresh ExplainedYes. Google Sheets pivot tables update automatically when the cells in their source range change; there is no…
- 24-Hour Gantt Chart Excel: 24 Setup Ideas That WorkTo make a 24-hour Gantt chart in Excel, put 24 hourly time values across the columns, list tasks…
- Microsoft Excel Dashboard: Build, Design, and Use OneA Microsoft Excel dashboard is a visual summary of important data, usually built from tables, PivotTables, charts, and…
- Pivot Table Sort by Value Not Working? Fixes in ExcelTo sort an Excel PivotTable by its numbers, click a value in the column you want to rank,…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.