Excel Pie Chart Labels: Use the Legend or Slice Text?

In Excel, a pie chart legend identifies each slice by matching its color to a category name; it does not place text on the slices. To show names, values, or percentages directly on the pie, add data labels, then remove the legend if it is no longer needed.

What the pie chart legend does

A legend is a key placed beside or near a chart. In a pie chart, each legend entry pairs a category name with the color used for that category’s slice. For example, a chart of quarterly expenses might show Housing beside a blue marker, Food beside an orange marker, and Transport beside a gray marker. Readers look back and forth between the pie and the key to identify slices.

Data labels do a different job: they display information next to, inside, or around the individual slices. A label can show the category name, the slice’s value, its percentage of the total, or a combination of those details. This distinction is useful when someone asks whether Excel can use the legend as a label. You can make the legend unnecessary by showing category names on the slices, but the legend itself does not turn into slice text.

Legend entries usually come from the category names in the chart’s source data. If the source table has generic names such as Item 1 or Item 2, those are what the legend will display until you replace them with meaningful names.

How to put labels on pie slices

In Excel for Microsoft 365 on Windows, select the pie chart and use the chart ribbon to add data labels. A straightforward sequence is:

Select the chart so the Chart Design tab appears.
Choose Chart Design > Add Chart Element > Data Labels, then select a position such as Center, Inside End, Outside End, or Best Fit.
To control what the labels show, choose Chart Design > Add Chart Element > Data Labels > More Data Label Options. Excel opens the Format Data Labels pane.
Under Label Options, select the items you want, such as Category Name, Value, or Percentage. Clear options you do not want.
If desired, select the legend and press Delete, or use Chart Design > Add Chart Element > Legend > None.

The exact positions available can depend on chart type and the available space. Excel may move outside labels or add leader lines to help connect text with a slice. On a Mac, select the chart and use the Chart Design tab and its Add Chart Element controls; the pane and ribbon labels can differ slightly by Excel release. Excel for the web supports chart labels, but its formatting controls may be more limited than the desktop app, so use Microsoft 365 for Windows or Mac when you need detailed label formatting.

Choose the right information for each label

Before turning on every label option, decide what a reader needs to learn from the chart. Showing category, value, and percentage together can be informative for a small pie, but it can also make a crowded chart difficult to read. These common combinations work for different purposes:

Category name only: useful when identifying the slices matters more than showing exact quantities.
Percentage only: useful when the key message is each category’s share of the whole.
Value only: useful when the actual amounts matter and the chart title or surrounding text explains what they measure.
Category name and percentage: a practical choice for many presentations because readers can identify a slice and understand its share.
Category name, value, and percentage: appropriate when the chart has only a few slices and the exact amount as well as the proportion is important.

For example, suppose monthly spending is $1,200 on Rent, $400 on Food, and $400 on Other. The total is $2,000, so the shares are 60%, 20%, and 20%. A label showing Rent, $1,200, and 60% communicates more than a color key alone, but three lines of text on every slice may be too much for a compact chart. Choose the minimum information that answers the chart’s purpose.

Keep the legend, remove it, or use both

Keeping the legend is sensible when labels are long, the chart has many categories, or placing text beside narrow slices would cause overlap. A legend also keeps the pie visually simpler. It is most useful when the key can sit close enough to the chart that readers can match colors without losing their place.

Removing the legend can free space and reduce the need to trace colors between the chart and a separate key. It works best when each slice has a clear data label and those labels remain readable at the chart’s final size. For a report viewed on a phone or printed in a small column, check the actual output rather than assuming labels that look good on a large screen will remain legible.

Using both is not automatically wrong. A legend can help when labels show only percentages, while the legend supplies category names. But if the same names appear in both places, the chart may feel repetitive. As a rule, keep both only when each element serves a distinct reading need.

Format labels so they stay readable

Excel provides several ways to adjust the appearance and placement of data labels. Select a label to open the Format Data Labels pane, then review Label Options and the text formatting controls. You can change the label position, number formatting, font, and fill or outline where the selected label style allows it. If values display too many decimal places, adjust the number format rather than editing each label by hand.

When labels sit outside the pie, leader lines can make it clearer which slice each label describes. When they sit inside, a contrasting font color may help them stand out against the slice fill. Avoid shrinking text until it is unreadable just to fit every label. A better solution may be to enlarge the chart, shorten category names in the source data, show fewer label fields, or move to a different chart type.

For custom label text, Excel can use cells as the source. In the Format Data Labels pane, choose Value From Cells and select a range that contains one matching label per slice. You can then clear Value if you do not want the underlying numbers displayed as well. This is useful when the source category names are long or when labels need extra context, such as a name and a brief note. Keep the helper cells in the same order as the chart categories so the text stays paired with the correct slices.

Common problems and how to fix them

The labels show numbers but not names: In Format Data Labels, select Category Name. Selecting Value alone displays the numeric data, not the category text.
The legend and labels show generic names: Update the category names in the source data, then confirm the chart reflects the revised range. Clear names in the data table usually produce unclear chart text.
Labels overlap or run into each other: Try Best Fit or Outside End, reduce the number of displayed fields, enlarge the chart, or use a legend. Very small slices have little room for internal text.
A label displays a value when a percentage was expected: Select Percentage in Label Options. Excel calculates that percentage from the slice’s share of the pie total; it is distinct from the raw value in the source cells.
The legend vanished but the chart is still understandable only by color: Add Category Name labels before deleting the legend, or restore it through Chart Design > Add Chart Element > Legend.

One common misconception is that changing the legend’s position changes what it says or places its entries on the slices. Position changes where the key appears, not the label content. To change the category text, edit the source category names; to display text on slices, use data labels.

When a pie chart is not the clearest choice

A pie chart is easiest to read when it represents parts of one meaningful whole, uses a modest number of categories, and has slices that differ enough to compare. If the chart has many tiny slices, long names, or several values that are close in size, data labels and a legend can both become crowded. Consider grouping small categories only when that grouping is meaningful and clearly explained.

A bar or column chart is often a better alternative when readers need to compare exact amounts or rank many categories. The lengths of bars are easier to compare than small differences in slice angles, and category names can sit beside the bars instead of competing for space around a circle. A doughnut chart can offer a similar part-to-whole view with a center opening, but it does not solve the basic challenge of too many categories. Choosing a different chart is often more effective than forcing every label onto a busy pie.

Frequently Asked Questions

Can I use the legend as labels in an Excel pie chart?
No. The legend is a separate color key. Add data labels to show category names, values, or percentages on the slices; then keep or remove the legend as appropriate.

How do I show category names on pie slices?
Select the chart, open Chart Design > Add Chart Element > Data Labels > More Data Label Options, and select Category Name in the Format Data Labels pane.

Can Excel show both a percentage and a category name?
Yes. In Format Data Labels, select both Category Name and Percentage. Clear options such as Value if you do not want the raw amount included.

How do I remove the legend but keep the slice labels?
Add and format data labels first. Then select the legend and press Delete, or choose Chart Design > Add Chart Element > Legend > None. Removing the legend does not remove data labels.

Why does my pie chart label show the value instead of the category?
The Value option is selected, while Category Name may not be. Open Format Data Labels and select Category Name; clear Value if the number is not needed.

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.