Excel Pie Chart: Display Percentages on Your Chart

To create an Excel pie chart that shows percentages, select the category names and values, choose Insert > Insert Pie or Doughnut Chart > 2-D Pie, then add data labels and turn on Percentage. In Excel for Microsoft 365 on Windows, you can do this from the Chart Design ribbon; the percentages are calculated from the values in the chart, so you do not need to calculate them first.

Prepare the Data for a Pie Chart

A pie chart works best when each value represents one part of a single whole. Put the category names in one column and the corresponding amounts in the next, with a header row. For example:

A1: Category; B1: Amount
A2: Apples; B2: 40
A3: Oranges; B3: 35
A4: Pears; B4: 25

The values add up to 100, so the resulting slices represent 40%, 35%, and 25%. They could also be counts, revenue amounts, or other comparable values that do not add up to 100: Excel calculates each slice as a share of the total. Use one row per category and avoid including a grand-total row in the chart selection. If you include that total, Excel may treat it as another slice and distort the result.

Pie charts are intended for one data series. If you have several groups to compare, such as sales by product across multiple years, a pie chart is usually not the right fit. Keep the category labels and their values together, and check for blank rows or text in the values column before creating the chart.

Create the Pie Chart in Excel

In Excel for Microsoft 365 on Windows, follow these steps:

Select the category names and values, including their headers. For the example above, select A1:B4.
Open the Insert tab.
Select Insert Pie or Doughnut Chart in the Charts group.
Choose 2-D Pie. This is the standard flat pie chart and is generally easier to read than a 3-D version.
Click the new chart to select it. If Excel has not added labels automatically, open Chart Design > Add Chart Element > Data Labels and choose a label position such as Outside End.

On Excel for Mac, select the data and use the Insert tab to choose a pie chart, then use the chart-design controls to add labels. Ribbon wording and layout can vary slightly by Excel release, but the chart’s label options provide the same Percentage setting. Excel for the web also supports pie charts, although controls may be arranged differently from the Windows desktop ribbon.

Turn On Percentage Labels

Adding data labels and displaying percentages are related but separate steps. After selecting the chart, open Chart Design > Add Chart Element > Data Labels > More Data Label Options. Excel opens the Format Data Labels pane. Under Label Options, check Percentage. To show the category beside each percentage, also check Category Name. If you want a clean percentage-only label, clear Value if it is selected.

You can also select a label on the chart, right-click, and choose Format Data Labels to open the same formatting pane. On a Mac, the pane may appear as a formatting sidebar. If you cannot find the options, make sure you selected a data label or the chart, not a worksheet cell. A label such as Apples 40% identifies both the slice and its share; a label showing only 40% is more compact but relies on a legend or other context to identify the category.

Percentage labels are calculated from the data currently plotted. They are not a new value written into your worksheet, and switching on Percentage does not change the underlying amounts. If you need percentages in cells as well as on the chart, calculate them separately in the worksheet.

How Excel Calculates the Percentages

For a basic pie chart, Excel divides each plotted value by the sum of the values in the series. In the example, the total is 40 + 35 + 25 = 100. Apples therefore account for 40/100, or 40%; oranges account for 35%; and pears account for 25%. If the values were 80, 70, and 50 instead, the total would be 200 and the shares would still be 40%, 35%, and 25%.

If you also want worksheet percentages, with category names in A2:A4 and amounts in B2:B4 (40, 35, and 25), enter this in C2 and fill it down through C4: =B2/SUM($B$2:$B$4). C2 returns 0.4, which displays as 40% when you apply percentage formatting; the next rows display 35% and 25%. Select the result cells and use Home > Percent Style to show them as percentages. This formula is optional: Excel can show percentage labels on the chart without a percentage column.

Rounding can make displayed labels add up to 99% or 101%, even when the underlying shares total exactly 100%. For instance, several values rounded to whole percentages may not sum neatly. That is a display-rounding effect, not necessarily a problem with the source data. Increase the number of decimal places in the label’s number format if the extra precision matters.

Format Labels and Improve Readability

Choose label settings based on the chart’s purpose and the amount of space available. Outside End labels can reduce crowding for medium-sized charts, while labels inside slices may work for a large chart with a few broad categories. A legend can identify categories, but putting the category name beside the percentage makes each share easier to understand when the chart is viewed on its own.

To change the appearance, select the labels and use the formatting options in the pane or the ribbon. You can adjust the font, number format, and label position. If labels overlap, try a larger chart area, fewer categories, or a legend instead of placing all names around the pie. Avoid relying only on color to distinguish slices: use clear category labels, and choose colors with enough contrast. A 3-D effect can make slice sizes look misleading because perspective changes how large they appear, so a 2-D chart is usually the clearer choice.

Use a descriptive chart title that explains what the shares represent and, when useful, the period covered. For example, Product Mix, Q2 is more informative than Chart Title. Check that the chart does not imply a percentage of a larger population than the data actually represents: a pie chart only describes the categories and values included in its plotted series.

Update the Chart When Data Changes

When you change a value in the chart’s source range, Excel recalculates the slice sizes and percentage labels. If you add a new category outside the original range, however, it may not appear automatically. You can expand the chart’s source data by selecting the chart and using Chart Design > Select Data, then adjusting the chart data range. You can also resize the highlighted source range on the worksheet when the chart is selected.

For data that will grow regularly, convert the source range into an Excel table by selecting it and choosing Insert > Table. Charts based on a table can include new rows as the table expands, which is useful for recurring reports. Check the chart after adding rows to confirm the new category is included and that the labels remain legible. If the chart is used in a presentation or report, verify that its title and category names still describe the updated data.

Common Problems and What to Check

The chart shows values but not percentages: Open Format Data Labels and check Percentage. The Value option alone displays the original amounts.
Percentages do not match expectations: Check which cells are included in the chart and whether a total, extra category, or unintended value is included. Excel uses the total of the plotted values.
A category is missing: Confirm that its name and number are inside the chart’s source range. Use Select Data to inspect or edit that range.
Some slices are hard to see: A zero value has no visible share, and negative values are not suitable for a pie chart. Check the source data and consider a different chart type if values can be zero or negative.
Labels overlap or appear crowded: Enlarge the chart, show fewer label details, use a legend, or choose a bar chart when there are many categories.
The percentages seem to total slightly more or less than 100%: Check the displayed decimal places. Rounded labels may not add up exactly even if the full-precision shares do.

A further common misconception is that a pie chart always represents a complete real-world total. Excel will calculate shares from the selected values, but it cannot tell whether the categories are exhaustive or whether any data was left out. Confirm that the plotted categories form the whole you intend to describe before presenting the chart.

When to Choose a Different Chart

A pie chart is most useful when you want to show how a small number of categories make up one whole at one point in time. If a reader needs to compare exact values, a bar or column chart is often easier because lengths can be compared more precisely than slice angles. If there are many small categories, labels become difficult to read; grouping minor categories is only appropriate when that grouping is meaningful and clearly explained.

For values changing over time, use a line chart rather than a separate pie for every date. For multiple series or comparisons across groups, consider a clustered bar or column chart. The goal is not simply to display percentages but to make the comparison easy to interpret. If the message depends on a precise difference, use direct labels or a table alongside the chart.

Frequently Asked Questions

How do I show both the category name and percentage?
Select the chart, open Chart Design > Add Chart Element > Data Labels > More Data Label Options, then check both Category Name and Percentage in Label Options.

Can Excel calculate pie-chart percentages automatically?
Yes. Add data labels and select Percentage in the Format Data Labels pane. Excel calculates each share from the plotted values; a separate formula column is not required.

Why do my pie-chart percentages not add up to 100%?
The underlying shares should total 100%, but rounded labels may appear to total 99% or 101%. Show more decimal places to reduce the difference. Also check that the chart includes only the intended categories.

Can I show percentages without showing the original values?
Yes. In Format Data Labels, check Percentage and clear Value. You can leave Category Name checked if readers need to identify each slice.

Can a pie chart display negative numbers?
Negative values do not represent parts of a whole and are not appropriate for a pie chart. Use a bar or column chart to compare positive and negative amounts, and check for zero values if a slice is missing.

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.