Excel Pie Chart Labels: Add, Format, and Troubleshoot

To add labels to an Excel pie chart, select the chart and choose Chart Design > Add Chart Element > Data Labels, then select a label position. To choose what each label displays, right-click a label, select Format Data Labels, and turn on options such as Category Name, Value, or Percentage.

What Excel pie chart labels show

A pie chart divides one data series into slices, with each slice representing a category’s share of the series total. Labels can identify slices and report their values or proportions, so readers do not have to estimate each slice from its angle or compare it with a legend.

For example, suppose a chart shows four product categories with values of 40, 30, 20, and 10. Their total is 100, so the corresponding percentages are 40%, 30%, 20%, and 10%. A label can show a category name, a value, a percentage, or a combination. Labels are especially useful when a chart has only a few slices and you want the reader to see the exact figures quickly.

Pie charts are designed for one data series. If the selected source range contains multiple series, Excel does not create a separate pie for each series in the way a clustered column chart would; check the chart’s selected data if the slices do not match what you expected. A pie chart is also most meaningful when the values are non-negative parts of a whole. Zero values have no visible slice, and negative values cannot be represented as ordinary shares of a total.

Add labels to a pie chart

These steps apply to Excel for Microsoft 365 on Windows. First create or select the pie chart, then add its labels from the ribbon:

Click the pie chart to show the chart-specific ribbon tabs.
Open Chart Design > Add Chart Element > Data Labels.
Choose a position, such as Center, Inside End, Outside End, or Best Fit. The available choices can depend on the chart type.
To change the label contents, right-click one of the labels and select Format Data Labels.
In the Format Data Labels pane, select the items you want, such as Category Name, Value, or Percentage. Clear any option you do not want.

Excel may initially show only a basic label, such as a value. Adding labels and choosing their contents are separate decisions: selecting Outside End sets a position, but it does not necessarily add category names or percentages. The checkboxes in the formatting pane control that information.

On Excel for Mac, select the chart and use the Chart Design tab’s Add Chart Element menu to find Data Labels; the layout and wording can vary slightly by release. In Excel for the web, chart editing controls can be more limited or arranged differently, so open the workbook in the desktop app if a specific formatting option is not available.

Choose the right label information

Which options you select depends on what the chart needs to communicate. A label that shows everything can be difficult to read, especially on a small chart. Consider these common choices:

Category Name: Identifies the slice, such as North, South, East, or West. This is often clearer than asking readers to match slice colors to a legend.
Value: Shows the underlying number, such as 40 units. Use it when the actual quantities matter more than their shares.
Percentage: Shows each value as a share of the total. Use this for a part-to-whole message, and confirm that the categories make up the intended whole.
Category Name and Percentage: Often a useful compromise: readers see both what a slice represents and how large its share is.
Legend Key: Adds a small color marker beside the label. This can help connect text labels with slice colors, though it may add visual clutter.

In the Format Data Labels pane, use the Separator control to choose how multiple items appear together. For instance, a comma separator can produce a compact label, while a new-line separator places the category and percentage on separate lines. If a label contains both a value and a percentage, remember that the value and percentage communicate different things: one is a quantity, the other is a proportion.

Percentage labels are calculated from the values represented in the chart, not from a percentage column that happens to sit beside the source data. If you need to show a separately calculated figure, check whether it is actually the chart’s share of the total before relying on Excel’s Percentage option.

Position and format labels for readability

Pie chart labels can sit inside the slices or outside the circle. Inside labels keep information close to its slice, but narrow slices may not have room for long category names. Outside End can give text more space, and Excel may draw leader lines to connect an outside label to its slice. Best Fit lets Excel choose placements, but it cannot guarantee that every label will be easy to read in every chart size.

To adjust placement, use Chart Design > Add Chart Element > Data Labels and try a different position. For more control, right-click a label and choose Format Data Labels. Depending on the chart and options selected, the pane can include leader-line and label-position controls. You can also resize the chart area to make more room around the pie rather than shrinking the label text until it becomes hard to read.

To change the label font or size, select the labels and use the Home tab’s font controls. A single click on a label usually selects the full set; clicking the same label again can select just that individual label. Individual formatting can be helpful for emphasizing one slice, but avoid manually replacing a label’s text with a typed value. A manually typed label may no longer update with the underlying data, making it easy for the chart to become inaccurate when values change.

For number formatting, open Format Data Labels and expand Number if that section is available. You can choose a number category and set decimal places; the Linked to source option, when shown, controls whether labels follow the source cells’ number format. Percentages with unnecessary decimal places can make a chart harder to scan, so use only the precision the reader needs.

Prepare the source data

A clear source table makes labeling simpler. Put category names in one column and the values in the next, with a header row, for example:

Product A — 40
Product B — 30
Product C — 20
Product D — 10

Select the category names and values when inserting the chart, or use Chart Design > Select Data to review or change the chart’s source range. If the chart has the wrong slice names, check that the category-name cells are included and that Excel has interpreted the rows and columns correctly. The chart’s labels draw their category names from the source data; they are not automatically inferred from nearby text that was left out of the selection.

Also check whether the values represent a complete whole. If your chart shows only selected categories, Excel’s percentage labels describe those plotted categories as a share of their combined total. For example, plotting values 40 and 30 alone makes their displayed shares about 57.1% and 42.9%, not 40% and 30%. That may be correct for the selected subset, but it can mislead if readers think the percentages represent a larger total.

Fix missing, incorrect, or crowded labels

If labels do not appear, select the chart and add Data Labels from Chart Design. If labels appear but show the wrong information, right-click one and inspect the checkboxes in Format Data Labels. Category names will not show if Category Name is off, and percentage text will not show if Percentage is off. If the labels are present but hard to see, check their font color, size, position, and whether the chart is too small.

When labels overlap, try these fixes in order:

Enlarge the chart or move it to a larger area of the worksheet.
Use shorter category names in the source table, or show fewer label components.
Try Outside End or Best Fit instead of placing long labels inside small slices.
Show percentages or values without category names, then use a legend if category identification is still needed.
Combine very small categories only when the combined group is meaningful and the underlying data supports it.

Small slices are a common reason labels collide or become difficult to associate with the right segment. A pie chart with many categories may not be a good way to present the data, even if Excel technically displays every label. Do not solve every overlap by reducing the font size: if the text is unreadable at the size the chart will be viewed, choose a clearer chart type.

If the percentages seem wrong, verify the chart’s source range and which categories are included. Check for omitted rows, hidden or filtered data settings, and values that are zero or stored as text rather than numbers. Also distinguish percentage of the plotted total from percentage of a fixed business-wide total; those are not necessarily the same calculation.

When a pie chart is not the best choice

A pie chart works best when you want to show a small number of categories that add up to a meaningful whole. When categories are numerous, values are similar, or readers need precise comparisons, labels can become crowded and slice angles are difficult to compare. A bar or column chart usually makes it easier to compare exact values and read long category names.

A doughnut chart uses a similar part-to-whole idea but has a hole in the center. It does not automatically solve the problem of too many slices or confusing labels. If the message is primarily about ranking categories, a sorted bar chart is often more direct; if the goal is to show change over time, a line chart may be more suitable. Choose the chart based on the comparison you want the reader to make, not just on which chart has the most decorative labels.

Frequently Asked Questions

How do I show percentages on an Excel pie chart?
Select the chart, open Chart Design > Add Chart Element > Data Labels, and choose a position. Right-click a label, select Format Data Labels, and check Percentage. Add Category Name too if readers need to identify each slice.

How do I show category names instead of numbers?
Right-click a chart label and choose Format Data Labels. Check Category Name and clear Value if you do not want the numbers displayed. If the names are missing or wrong, confirm that the chart’s source range includes the category-name cells.

Can Excel show both a value and a percentage?
Yes. In Format Data Labels, select both Value and Percentage. You can also select Category Name, but using all three can make the chart crowded, particularly when labels sit outside a small pie.

Why do my pie chart percentages not match my source percentages?
Excel calculates Percentage from the values included in the chart. If you chart only part of a larger dataset, those values are treated as the whole for the displayed chart. Confirm the selected range and decide whether the chart should show shares of the subset or of the full total.

How can I stop pie chart labels from overlapping?
Make the chart larger, shorten category names, remove unnecessary label details, or move labels outside the slices. If the chart still cannot fit the labels clearly, use a bar chart or show fewer categories rather than making the text too small to read.

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.