Excel Pie Chart: Show Percentages Clearly

Yes. In Excel for Microsoft 365 on Windows, select the pie chart, then choose Chart Design > Add Chart Element > Data Labels > More Data Label Options and check Percentage in the Format Data Labels pane. Clear Value if you want percentages without the underlying numbers; Excel calculates each displayed percentage from the values in the chart.

Show percentage labels on a pie chart

First create or select a pie chart based on a category column and a numeric-value column. With the chart selected, use the ribbon path above to open the label settings. In the Format Data Labels pane, under Label Options, select Percentage. You can also select Category Name to identify each slice, or Value to show its source number. If you want a simple percentage-only chart, select Percentage and clear the other label options.

Click the pie chart so the chart-specific ribbon tabs appear.
Choose Chart Design > Add Chart Element > Data Labels > More Data Label Options.
In the Format Data Labels pane, turn on Percentage.
Turn off Value or other label options you do not want, then close the pane.

For a faster route, select the chart and use the Chart Elements button, shown as a plus sign beside the chart in desktop Excel. Expand Data Labels and choose More Options to open the formatting pane. The precise buttons may look different with window size or ribbon layout, but the label settings provide the same choices. Adding labels does not change the worksheet data; it changes what the chart displays.

How Excel calculates each percentage

A pie chart shows each plotted value as a share of the total of the values in its one data series. For example, suppose a chart contains three categories with values of 120, 80, and 50. Their total is 250, so Excel displays 48%, 32%, and 20%, respectively. The percentages add to 100% before any rounding in the labels.

That distinction matters when the source numbers are counts, dollars, hours, or another measure. You usually do not need to calculate percentage values in a separate worksheet column: turn on the Percentage label option and Excel derives each slice’s share. If the values are 12, 8, and 5, the shares are still 48%, 32%, and 20%. The chart uses the relative sizes, not the units or the absolute total.

Excel calculates the share from the data included in the chart, not necessarily every row in the worksheet. If you exclude a category from the chart’s source range, the remaining slices are recalculated to make up the whole. Likewise, filtering or changing the plotted range can affect which categories are represented. Check the chart data selection if the percentages do not match the total you expected.

Choose useful labels and control their appearance

Percentage alone can be hard to interpret if readers cannot tell which slice it belongs to. For a small chart or a presentation, Category Name and Percentage together are often more informative. Value and Percentage can also be shown together when both the share and the original amount matter, although that can make a busy chart difficult to read.

To change label placement, open Format Data Labels and use the Label Position choices, such as Best Fit, Center, Inside End, or Outside End when available for the selected chart type. The best location depends on slice size and the amount of text. A narrow slice may not have room for a label inside it; outside labels or a legend can make the category clearer. If labels overlap, try a different position, shorten category names, enlarge the chart, or remove nonessential label details.

You can also adjust the displayed precision. In the label-formatting pane, look for the Number section and set the number format and decimal places for the labels. Whole percentages are often easiest to scan; decimal places can help when values are close, but may create clutter. Rounding can make the visible labels appear to total 99% or 101%, even though the underlying shares total 100%. For instance, three values with exact shares near one-third may display as 33%, 33%, and 33% when rounded to whole numbers.

Prepare source data for an accurate pie chart

Use one category field and one series of nonnegative values. A basic table might list product names in the first column and units sold in the second. Select the relevant cells, then insert a pie chart from Insert > Insert Pie or Doughnut Chart. If you already have a chart, use Chart Design > Select Data to inspect or adjust the data range. Clear headings and a single, well-defined measure help Excel and the reader understand what the slices represent.

Before relying on the percentages, check the data for issues that can distort the whole:

Exclude totals and subtotals from the plotted range. Including a grand total as another slice counts the same amounts twice.
Decide whether blank cells, zero values, or categories outside the question belong in the chart. A zero has no visible slice, while a category omitted from the range is not part of the displayed whole.
Check that each row represents a distinct category and that the values use the same unit and time period.
Review hidden or filtered data if the chart appears to omit a category; chart settings can determine whether hidden data is plotted.

Pie charts work best when the categories are mutually exclusive parts of one meaningful total. If a person can be counted in multiple categories, or if categories measure different things, the slices may not describe a genuine whole even if Excel can draw the chart. The percentages will still be calculated from the plotted values, but the result may be misleading.

Fix percentages that are missing or unexpected

If percentages do not appear, confirm that the pie chart itself is selected and that Percentage is checked in Format Data Labels. A chart may show values or category names but not percentages if those options alone are selected. If you cannot see the labels, they may be too small, outside the visible chart area, or obscured by other labels. Resize the chart or change the label position before assuming the option failed.

If the percentages look wrong, inspect the chart’s selected range and its values. A common mistake is including a total row, which adds the total to the categories and changes every share. Another is expecting a category’s percentage of a broader dataset when the chart includes only a subset. Excel uses the plotted values as the denominator, so a selected subset is treated as 100% of the pie.

Also check for negative values or data that should not be combined. A pie chart represents nonnegative parts of a whole; negative amounts do not have a meaningful positive slice. If the source includes refunds, losses, or other negative figures, choose a chart type that can represent the signs and comparisons appropriately instead of forcing the data into a pie chart. Finally, remember that a displayed percentage may be rounded: increase decimal places temporarily to distinguish a rounding issue from a range or data problem.

When a pie chart is the right choice

A pie chart is most useful when the question is about composition at one point or over one defined period, and there are only a few categories. A clear example is the share of a department’s budget divided among four expense groups. The circle emphasizes that the categories together make up a whole, and percentage labels answer how large each part is.

It is less effective when there are many categories, several slices are nearly the same size, or readers need to compare values precisely. People generally find it easier to compare aligned bar lengths than small differences in slice angles. A bar or column chart is often clearer for ranking categories, comparing several periods, or showing changes over time. A doughnut chart can display the same kind of part-to-whole data, but it does not solve problems caused by too many categories or tiny differences.

As a practical rule, retain a pie chart when the whole is meaningful, the category count is limited, and the largest comparisons are obvious. If you need a long legend, many tiny slices, or exact comparisons between similar shares, consider a bar chart and label the values or percentages there. The chart type should make the answer easier to see, not merely fit the data.

Excel for Mac and Excel for the web

In Excel for Mac, pie charts also support percentage data labels. Select the chart and use the chart-design and data-label formatting controls; ribbon wording or the arrangement of options can vary by release. The same core idea applies: enable Percentage in the label options and disable Value if it should not appear. If a ribbon command is not visible, look for the chart’s formatting pane or its chart-element controls.

Excel for the web can create and edit charts, but its chart-formatting controls may not expose every option in the same place or with the same detail as the Windows desktop app. If you cannot find a label-position or number-format setting in the browser, open the workbook in the desktop version of Excel and make the change there. The chart and its source data remain part of the workbook, so the desktop formatting can be saved for other viewers.

Frequently Asked Questions

Can Excel show both the percentage and the value?

Yes. In Format Data Labels, select both Percentage and Value. You can also add Category Name. Use only the details readers need, because showing all three can crowd a chart with several slices.

Do I need to calculate percentages in the worksheet first?

No. For a pie chart, Excel can calculate each slice’s share when you enable Percentage in the data-label options. Worksheet percentages are useful if you need to reuse them elsewhere, but they are not required just to label the chart.

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

They may be rounded for display. Increase the number of decimal places to see more precision. Also check that the plotted range does not include a total row or omit categories you intended to include.

Can I show a percentage in the legend instead of next to each slice?

The percentage option applies to data labels, not automatically to the legend text. To make the legend identify shares, use category-and-percentage labels near the slices or create worksheet labels that include the desired text and use those as chart category names.

Why is the percentage calculated from only some of my rows?

The chart calculates shares from its plotted data range and its chart settings for hidden or filtered data. Use Chart Design > Select Data to inspect the range, and verify that the intended rows are included. A filtered chart may not represent the same total as the full table.

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.