Excel Pie Chart Labels on Slices: How to Add Them

To put labels directly on pie slices in Excel for Microsoft 365 on Windows, select the chart, then choose Chart Design > Add Chart Element > Data Labels > Center or Inside End. To show category names, values, or percentages, right-click a label, choose Format Data Labels, and select the details you want in the Format Data Labels pane.

Add labels to a pie chart

Start with a simple table: put category names in one column and their numbers in the next. For example, a budget chart might list Housing, Food, Transport, and Other beside 900, 450, 250, and 400. Select the table, then choose Insert > Insert Pie or Doughnut Chart and select a 2-D Pie chart. Once Excel creates the chart, click it so the chart tabs appear on the ribbon.

Use Chart Design > Add Chart Element > Data Labels, then choose a position such as Center or Inside End. Center places the label around the middle of each wedge; Inside End puts it closer to the outer edge of the slice. The exact positions offered can vary with the chart type. If labels are already present, select the chart and use the same menu to change their placement rather than adding another set.

You can also right-click a slice and choose Add Data Labels, then right-click a label and choose Format Data Labels to adjust what it displays. Depending on the context menu and chart state, Add Data Labels may initially show the values. Use the Format Data Labels pane to change the content and positioning. Click a blank area of the chart when you are finished editing individual labels.

Choose what each slice label shows

Excel can display several kinds of information on a pie chart. In the Format Data Labels pane, under Label Options, choose the items that fit the purpose of the chart:

Category Name: the text from the category column, such as Food.
Value: the underlying number, such as 450.
Percentage: that slice’s share of the total series.
Series Name: the name assigned to the data series, if one is available.
Legend Key: a small color marker matching the slice.

For the example budget values of 900, 450, 250, and 400, the total is 2,000. Their percentages are 45%, 22.5%, 12.5%, and 20%. If you select both Category Name and Percentage, a slice can read Housing 45%. If you select Value instead, it can show Housing 900. Select Percentage when readers need to compare shares; use Value when the actual amounts matter. Showing category, value, and percentage together is possible, but often makes labels crowded.

The percentage is calculated from the values represented by the pie, not from a separate percentage column. In this example, Excel divides each value by 2,000 to determine its share. If you change the data, the displayed percentages update with the chart. A percentage label may be rounded for display, so visible percentages can add up to 99% or 101% even though the underlying shares total 100%.

Put labels inside or outside the slices

Inside labels work well when the chart has a small number of categories and each slice is large enough to hold readable text. Center and Inside End are common choices for this layout. If the slices are narrow, or category names are long, labels can overlap or become too small. A label being technically inside a slice does not guarantee that it will be legible at the chart’s final printed or displayed size.

For crowded charts, choose Chart Design > Add Chart Element > Data Labels > Outside End. Excel positions labels beyond the pie, where longer text has more room. You can also enable leader lines in the Format Data Labels pane when that option is available. Leader lines connect a label to its wedge, which helps readers identify small slices. If labels are difficult to follow, move them or use a legend instead of forcing every label into the pie.

Try resizing the chart before reducing the font substantially. A larger chart can make inside labels easier to read and give outside labels more room. When exporting, printing, or placing the chart in a report, check it at the size readers will actually see. Labels that appear clear on a large worksheet may collide after the chart is copied into a narrow document column.

Format labels for clarity

Click a data label once to select all labels, then use the formatting controls on the Home tab or the Format Data Labels pane. To edit one label separately, click the label set once and click the specific label again; then change its text formatting or move it. Be careful not to delete a label accidentally while trying to select it. If one label is removed, you can add labels again through Chart Design > Add Chart Element > Data Labels.

For numbers, the pane’s Number section lets you choose a format such as Number, Currency, or Percentage and set decimal places. A value of 450 can be displayed as 450, 450.0, or a currency amount, depending on the format you choose and the underlying data. Category names and numeric labels have separate purposes: formatting the value does not rename a category. Change the source cell text if the category wording needs to change.

Use enough contrast between the label text and the slice fill. A dark font on a pale slice and a light font on a dark slice are generally easier to read than low-contrast combinations. Keep font sizes consistent and avoid using color as the only way to distinguish categories; the category names should remain clear even for readers who cannot easily distinguish the slice colors.

Keep labels connected to the right data

Chart labels are linked to the chart’s source data. If you edit a category name or number in the worksheet, the chart normally reflects the change. If you add a new row after creating the chart and it does not appear, the chart’s source range may not include that row. Select the chart and choose Chart Design > Select Data to review the chart data range and adjust it if needed.

Make sure the selected data contains the category labels and the values, not a total row that should not be a slice. Including a total as another pie value changes the denominator and makes every displayed percentage misleading. For example, selecting four budget categories plus their 2,000 total creates a pie with five slices; the total then takes half of the displayed pie because it equals the sum of the other values. Exclude totals from the plotted range.

Pie charts represent parts of one whole, so the values should be comparable categories from the same period or basis. A pie is not a good way to combine unrelated measures or multiple series. If you need to compare category values across several months, use a column or line chart rather than adding several series to one pie.

Fix common label problems

If labels do not appear, first confirm that the chart is selected and that Data Labels are enabled in Chart Design > Add Chart Element. Then open Format Data Labels and check that at least one label content option is selected. If labels are present but show the wrong information, verify whether Value, Category Name, or Percentage is selected; Excel does not infer which type you intend.

When labels overlap, try these remedies in order:

Move labels outside the pie or choose another available position.
Show fewer items, such as category and percentage rather than category, value, and percentage.
Shorten category names in the source data or make the chart larger.
Use a legend for category names and keep only percentages or values on the slices.
Group very small categories when that grouping is meaningful and accurately represented.

If a label displays an unexpected percentage, check the chart’s selected data range and remove any total or unintended rows. Also confirm that the pie contains the intended single series. Rounding alone can explain small differences in the displayed percentages, but it does not explain a large discrepancy. If a value appears in an odd format, select the labels, open Format Data Labels, and review the Number settings.

When a pie chart is not the best choice

Direct labels are useful when there are only a few categories and readers need to identify each slice without looking back and forth to a legend. But a pie chart becomes hard to interpret when it contains many similar-sized wedges, long names, or several tiny categories. There is no fixed category count that makes every pie unreadable; the practical test is whether readers can identify and compare the slices without confusion.

For precise comparisons, a sorted bar chart is often clearer because people can compare lengths more reliably than angles. A bar chart also gives long category labels more room and can show many categories without crowding the plot. A doughnut chart supports similar data labels, but its hole does not make the proportions easier to compare. Choose the chart that communicates the data, not merely the one that offers the most label options.

A legend can be preferable when labels would cover the slices, while direct labels are often preferable when a small pie has only a few categories. It is also reasonable to combine approaches: show percentages on the slices and use a legend for the category names. Avoid repeating the same information in the chart, legend, and a separate label block unless the repetition serves a clear purpose.

Excel on Mac and the web

In current desktop versions of Excel for Mac, select the chart and look for the Chart Design tab and its Add Chart Element and Data Labels controls. The exact ribbon arrangement can vary by release, but the label choices and Format Data Labels pane follow the same general workflow as Windows. If a command is not visible, use the chart’s contextual menu or search for the command in Excel rather than assuming the feature is unavailable.

Excel for the web also supports chart labels, although its chart formatting controls may be more limited or arranged differently from the Windows desktop app. If you cannot find a specific label position or formatting setting in the browser, open the workbook in desktop Excel and make the change there. The chart remains part of the workbook, so desktop formatting can be useful when preparing a polished report.

Frequently Asked Questions

How do I show percentages on pie slices in Excel?
Select the chart, choose Chart Design > Add Chart Element > Data Labels, and add labels. Right-click a label, choose Format Data Labels, and select Percentage under Label Options. Clear Value if you do not want the raw numbers displayed.

Can I show the category name and percentage together?
Yes. In the Format Data Labels pane, select both Category Name and Percentage. If the text becomes crowded, move labels outside the pie, enlarge the chart, or use a legend for the category names.

Why do my pie chart percentages not total exactly 100%?
Excel calculates each share from the values in the pie, but displayed percentages may be rounded. A chart showing whole percentages might total 99% or 101% even when the underlying proportions total exactly 100%. Also check that the chart range does not include a total row.

Can I change the wording on one slice label?
Category labels normally come from the worksheet cells, so edit the relevant source cell to change the category wording. To format one label differently, select the label set and then select that individual label again before applying formatting.

How do I remove labels from a pie chart?
Select the chart and choose Chart Design > Add Chart Element > Data Labels > None. You can also select a label and press Delete, but removing labels through the chart menu makes it clearer that you are turning off the chart’s label display.

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.