Excel Pie Chart Legend on Slices: How to Add Labels

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; in the Format Data Labels pane, select Category Name to put each slice’s label directly on the chart. A legend is a separate chart element, so you can remove it once the slice labels make it unnecessary.

What a Legend on a Pie Slice Really Means

Excel does not move a legend onto the slices. A legend is a separate key that matches colors to category names, usually displayed beside or below a chart. Text printed next to or inside a slice is a data label. People often describe the result as a legend on the slices, but the practical solution is to add category-name data labels and, if desired, turn off the separate legend.

For example, suppose a pie chart shows sales for four departments: Books, Games, Music, and Gifts. A legend makes readers match each department name to a colored square and then find the same color in the pie. Category-name labels put Books, Games, Music, and Gifts right beside their corresponding wedges. That can make a small chart easier to understand, especially when readers will see it in a report or presentation without an explanation.

Data labels can show more than names. Depending on what you select, they can display a category name, the value behind a slice, its percentage of the pie, or combinations of those items. The best choice depends on whether the reader needs to identify categories, compare amounts, or understand each category’s share of the total.

Add Category Names to the Slices

These steps apply to the desktop version of Microsoft Excel for Microsoft 365 on Windows. First, make sure the chart is a pie chart and that its source data has category names alongside the numbers. Then:

Select the pie chart to show the chart-specific ribbon tabs.
Choose Chart Design > Add Chart Element > Data Labels > More Data Label Options. The More Data Label Options command opens the formatting controls for labels.
In the Format Data Labels pane, under Label Options, select Category Name. Excel displays the category names associated with the slices.
Clear Value if you want names without the underlying numbers. Clear Percentage too unless a share of the total is useful to your readers.
Use the Label Position choices to put the labels inside or outside the slices, where available and legible.

You can also add labels more quickly from Chart Design > Add Chart Element > Data Labels and choose a position. Then open More Data Label Options to choose exactly what each label contains. The quick position choices add labels, but checking the specific label-content boxes is what controls whether they show names, values, or percentages.

On Mac, select the chart and use the Chart Design tab and its Add Chart Element controls; the Format Data Labels pane provides the label-content settings, though the layout can differ slightly by Excel release. Excel for the web has chart-label controls as well, but some formatting choices may be more limited than in the Windows desktop app. If a control is missing, opening the workbook in desktop Excel is the most reliable way to use the full set of label options.

Choose What Each Label Shows

In the Format Data Labels pane, Excel lets you combine available information. For a typical pie chart, the useful choices are Category Name, Value, and Percentage. You can select more than one, but every added item makes the text denser. A label that says “Books 40 40%” may be technically informative yet harder to scan than “Books 40%.”

Category Name: Identifies the slice, such as Books or Games. This is the setting most people mean when they ask for a legend on the slices.
Value: Shows the number in the source data. Use it when exact amounts matter, such as units sold or dollars recorded.
Percentage: Shows the slice’s share of the total represented by the pie. It is useful for composition, but rounded percentages may not sum to exactly 100%.
Series Name: Identifies the data series. A simple pie chart usually has one series, so this is often less useful than the category name.
Legend Key: Adds a small color marker to a label. It can help connect text and slices, but may be redundant when each label is placed clearly beside its wedge.

As a simple example, if the chart contains values of 40, 30, 20, and 10, the percentages are 40%, 30%, 20%, and 10%, because the total is 100. If the values are 400, 300, 200, and 100, the same percentages apply. Category names explain what the wedges represent; values preserve the actual quantities; percentages emphasize the shares.

Excel calculates percentage labels from the data represented in the pie, not from a percentage typed into a separate cell. If the chart’s source data or plotted categories change, the displayed percentages can change too. Review the labels after filtering or editing the source, particularly if the chart is configured to include or exclude hidden data.

Control Label Position and Readability

After choosing the content, set a position that keeps labels associated with the right wedges. Depending on the chart and Excel version, the position choices include options such as Center, Inside End, Outside End, and Best Fit. Center places text in the middle of a slice; Inside End puts it toward the outer edge while remaining within the slice; Outside End places it beyond the pie. Best Fit lets Excel choose placements, but it does not guarantee that every label will be easy to read.

Small slices are the main challenge. A long category name may not fit inside a narrow wedge, and labels placed outside can crowd one another. Try a short label, a smaller font, or an outside position with leader lines. Leader lines connect an external label to its slice, reducing the chance that a reader will mistake which wedge it describes. In the Format Data Labels pane, look for the option to show leader lines when it is available for the selected position.

Formatting can improve legibility, but avoid making text so small that it is unreadable at the chart’s final size. Select a data label to format the labels as a group, or select an individual label if you need to adjust one separately. Check the result at the size where it will actually appear: a chart that looks clear when enlarged may become cramped when pasted into a slide or printed on a page.

Use Custom Text from Cells

If the source category names are too long or need special wording, Excel can use text from worksheet cells for data labels. In the Format Data Labels pane, select Value From Cells, then choose the range containing the label text. The range should have one label for each pie category and should be in the same order as the categories in the chart. Confirm the range selection, and clear other label-content options such as Value if you want only the custom wording.

For example, a source table might use “North American Online Sales” as a category, while a compact chart should say “North America.” Put the shorter display text in a separate worksheet range and use that range for the labels. This avoids changing the underlying data categories, which may also be used in a table, formula, or other chart. If the chart categories are reordered, check that the custom label range still lines up with them; mismatched order can attach a correct name to the wrong slice.

Value From Cells is also useful when you want labels with line breaks or carefully prepared wording. Keep the text concise, since custom labels do not solve the basic space limitations of a crowded pie chart. If you cannot find the option in your Excel build, use the category names in the source data or open the file in a supported desktop version.

Remove or Keep the Separate Legend

Once each slice is labeled, a second key may repeat the same information. To remove it, select the legend and press Delete, or choose Chart Design > Add Chart Element > Legend > None. Removing the legend does not remove the data labels. If you later want the legend back, use the same menu and select a position such as Right, Top, or Bottom.

Keeping both can still make sense. A legend can act as a compact color key when labels are outside the pie, when the chart is small, or when some categories do not have room for full text. Conversely, if every slice has a clear name beside it, the legend often consumes space without adding information. Choose based on the finished layout rather than assuming one arrangement is always correct.

Fix Common Label Problems

The labels show numbers instead of names: Open Format Data Labels and select Category Name. Clear Value if the numbers are not wanted.
The labels show percentages but no category names: Select Category Name as well as Percentage. Check that the labels have enough room for both.
A category name is missing or incorrect: Check the chart’s source range and category labels. If using Value From Cells, verify the selected range and its order.
Labels overlap: Try Best Fit or Outside End, shorten the category text, enlarge the chart, or use fewer categories. A pie chart with many narrow wedges can become unreadable even with careful formatting.
Text is hard to read against a slice: Move labels outside, adjust the font or label formatting, or choose slice colors with stronger contrast. Do not rely on color alone to identify categories.
Some slices have no visible label: A label may be crowded out or hidden by limited space. Increase the chart size, use a shorter label, or position labels outside; inspect the smallest wedges individually.

If a chart has many categories, the problem may be the chart type rather than a setting. A pie chart works best when the reader needs to compare a small number of parts of one whole. With numerous categories or several very small slices, a bar chart can make category names and values easier to compare. That is a design choice, not a failure to find the right legend option.

When Slice Labels Are Better Than a Legend

Direct labels are often effective when the chart has a modest number of categories, labels are short, and the pie is large enough for text. They reduce the eye movement involved in matching a legend color to a wedge. This can be especially useful in a standalone graphic where readers should understand the categories immediately.

A legend may be preferable when category names are long, when there are many slices, or when the pie must remain compact. Another option is to label slices with percentages and provide the full category names in a nearby table or note. For an accessible report, include meaningful text in the surrounding document as well; readers should not have to infer a category from color alone. The right choice is the one that makes the chart’s message clear without crowding it.

Frequently Asked Questions

Can I put the legend inside an Excel pie chart?
Excel’s legend remains a separate chart element; it is not embedded onto individual wedges. To get the same practical effect, add Category Name data labels to the slices and remove the legend if it repeats that information.

How do I show both the name and percentage on each slice?
Select the chart, open Chart Design > Add Chart Element > Data Labels > More Data Label Options, then select Category Name and Percentage in the Format Data Labels pane. Adjust the position if the combined text is crowded.

How do I remove the legend but keep the labels?
Select the legend and press Delete, or choose Chart Design > Add Chart Element > Legend > None. Data labels are separate, so they remain on the chart.

Why do the percentages not add up to exactly 100%?
Excel calculates the shares from the values, but displayed percentages may be rounded. For example, several values that each round to a whole percentage can produce displayed labels whose sum is slightly above or below 100% even when their underlying shares total 100%.

Can I use shorter labels without changing the source categories?
Yes. In Format Data Labels, select Value From Cells and choose a range containing the shorter display text, with one entry per category in matching order. If that option is unavailable in your version, use concise category names in the chart’s source data.

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.