How to Rename a Legend in an Excel Pie Chart

Charts & pivot tables · Updated November 20, 2026

To rename a legend item in an Excel pie chart, change the category name in the worksheet cell that supplies the chart’s labels. The legend usually reflects those category cells, so editing the chart’s data labels is not the same as renaming its legend. If the chart uses a different label range, use Chart Design > Select Data to point it to the correct cells.

These steps are for Excel for Microsoft 365 on Windows. They apply to most pie charts in current desktop versions of Excel as well. First, identify the worksheet data connected to the chart; changing a label in the wrong place will not update the legend.

What You’ll Need

  • An Excel workbook containing the pie chart.
  • Permission to edit the workbook and its source data.
  • A way to identify which worksheet cells provide the pie slices’ category names. If you are unsure, the Select Data dialog can help you locate the label range.

Step-by-Step

  1. Find the category names in the worksheet. Click the chart once, then look at the data it represents. A common layout has category names in one column and the values for each slice in the next, such as names in A2:A5 and values in B2:B5. Your workbook may use different columns, a table, or data arranged in rows. The names associated with the slices—not the numbers—are usually what appear in the pie chart legend.
  2. Identify the exact label you want to change. Match the legend entry to its source cell before editing. For example, if the legend says “North,” find the cell containing “North” in the chart’s category-label range. If several charts use the same source cell, changing it may update all of them. Consider whether that is intended before making the change.
  3. Edit the source cell. Select the cell and type the replacement name, then press Enter. For instance, you might change “North” to “Northern Region.” The corresponding legend entry should update automatically because the chart is linked to that cell. Excel does not normally provide a separate text box for independently typing a new name into a pie-chart legend item.
  4. Check that the chart updated. Click away from the cell and inspect the legend. Confirm the new wording is correct, readable, and associated with the intended slice. If it has not changed, do not keep editing similar-looking cells at random. The chart may be using another label range, or its data source may not include the cell you changed.
  5. Open the chart’s data-source settings if needed. Select the chart, then choose Chart Design > Select Data. In the Select Data Source dialog, look for Horizontal (Category) Axis Labels. In a pie chart, this is the list of category labels used for the slices and legend. The Legend Entries (Series) area generally shows the single series of pie values; it is not where you change individual slice names.
  6. Review or reset the category-label range. In Select Data Source, under Horizontal (Category) Axis Labels, select Edit. Check the range shown in the Axis Labels dialog. If it points to the wrong cells, select the range containing the intended category names, then confirm with OK. Click OK again to close Select Data Source. The legend should now reflect the names in that range. Make sure the selected range contains the same number of labels as there are pie values.
  7. Adjust the worksheet label if the chart is now using the right range. Once you have confirmed the correct range, edit the desired category cell as described above. This keeps the worksheet and chart consistent: anyone looking at the source data can see the same name that appears in the legend. If you are using an Excel table, edit the relevant table cell; the chart can continue to use the table’s category and value columns.
  8. Check other chart text separately. A pie chart legend has entries but usually has no separate legend title. If you meant to change a data label printed beside a slice, that label may display the category name, the value, or a percentage. Select the chart and use Chart Design > Add Chart Element > Data Labels > More Data Label Options to review which details are displayed. Changing a data label’s display options does not rename the underlying legend entry.

In Excel for Mac, the chart tools and Select Data controls are available, though dialog layout and ribbon placement can differ slightly. Select the chart and look for Chart Design > Select Data. Excel for the web supports many chart and worksheet edits, but some chart-source controls may be more limited or arranged differently. If you cannot find the label range or the dialog does not offer the needed control, open the workbook in the desktop version of Excel.

Common Mistakes

  • Changing the values instead of the names. A pie chart uses numeric values to determine slice sizes and category names to identify the slices. Editing a value can change the pie proportions without changing the legend wording. Locate the cell containing the displayed text before editing.
  • Editing the series name. A pie chart normally has one data series, while each legend entry represents a category or slice. Renaming the series is not a reliable way to rename an individual legend item. Check Horizontal (Category) Axis Labels in Select Data instead.
  • Typing over the visible legend. The legend is generated from the chart’s data, so its entries are generally linked to source cells. Trying to treat a legend item like a standalone worksheet cell will not change the connected category name. Edit the source label or select the correct category-label range.
  • Assuming every chart uses the cells beside its values. A chart may refer to a separate label column, a table, or a range on another sheet. Use Select Data to inspect its references rather than relying on how the worksheet happens to look.
  • Including a heading or omitting a label in the selected range. If the label range starts on the wrong row, the chart may show a heading as a slice name or pair labels with the wrong values. Check the first and last cells in the range and confirm each pie value has exactly one category label.

Tips

  • Use concise names. Long legend entries can wrap or make the chart crowded, especially when the chart is small. Use a short, clear category name in the source data. If a full description is important, include it in a nearby note or a supporting table rather than shrinking the chart text until it is difficult to read.
  • Keep labels distinct. Two slices with identical names can make the legend confusing even if their values differ. Give each category a name that readers can distinguish. If the categories really are the same, consider whether they should be combined before presenting the pie chart.
  • Use the source cell as the normal place to make edits. This preserves the link between the chart and the worksheet. It also means a later correction to the category name is easy to make and is less likely to leave the chart inconsistent with the data table.
  • Check what happens when labels change length. A longer name may push the legend farther from the pie or cause wrapping. Resize the chart or reposition the legend if necessary. Select the chart and use Chart Design > Add Chart Element > Legend to choose a legend position, or drag the legend within the chart area.
  • Make a copy before a larger chart cleanup. If you are changing several source ranges or reorganizing the underlying data, save a copy of the workbook first. That gives you a straightforward way to compare the original chart and restore the prior setup if the new labels become mismatched.

Troubleshooting

The legend does not change after I edit a cell. Select the chart and open Chart Design > Select Data. Inspect Horizontal (Category) Axis Labels to see which cells supply the legend text. You may have edited a duplicate label, a title, or a cell outside the chart’s range. If the chart refers to another worksheet, follow the range shown in the dialog and edit that source cell.

The chart shows numbers or the wrong words in the legend. Reopen the Axis Labels dialog and select the intended category-name cells. Check that the selected range contains text labels and aligns one-for-one with the values. If the labels and values are arranged by rows rather than columns, review the chart’s source arrangement and the ranges displayed in Select Data; do not switch rows and columns unless that matches how your data is organized.

The legend changed, but the text beside the slices did not. The chart legend and data labels are separate elements, even when they both show category names. Select the chart and open the data-label options to check whether Category Name is selected. If the labels are manually customized or display only values or percentages, change their options as needed. The legend entry itself still comes from the category-label range.

The new name is cut off or hard to read. Shorten the source label if a compact name is suitable, enlarge the chart, or move the legend to a less crowded position. You can also resize the legend area by selecting it and dragging its handles. Avoid reducing the font too far; a readable chart is more useful than one that preserves every word in a cramped legend.

Select Data is unavailable or the dialog looks different. Make sure the chart itself is selected, not just a cell or a text label. In Excel for the web, some chart editing controls may not match the Windows desktop dialog. Try opening the workbook in Excel for Microsoft 365 on Windows, then select the chart and choose Chart Design > Select Data. If the file is read-only, obtain editing permission first.

Frequently Asked Questions

Can I rename a pie-chart legend item without changing the worksheet data?

Normally, the legend entry is linked to the category label in the chart’s source data, so editing that cell is the standard approach. If you need different wording on the chart while preserving the original data, you can create a separate set of display labels in other cells and set the chart’s category-label range to those cells. This leaves the original names intact but means you must keep the display labels up to date.

Why does a pie chart show category names in the legend?

A pie chart’s legend identifies its slices. Excel typically takes those names from the chart’s category-label range, while the numeric values determine the size of the slices. A pie chart usually contains one series, so its individual legend entries correspond to categories rather than separate series names.

Can I change the legend title in an Excel pie chart?

Excel pie charts do not normally include a separate legend title to rename. If you need a heading for the legend, add text to the chart as a separate element, such as a text box, and position it above or beside the legend. Remember that this heading is separate from the category names and will not update automatically from a legend-title setting.

How do I rename all the entries in a pie-chart legend?

Edit each category name in the chart’s label range, or replace the label range with a range containing all the desired names. Check that the order of the labels matches the order of the pie values. If several charts share those source cells, the changes may also update their legends.

Will renaming a legend entry change the size of its pie slice?

No. Changing a category label changes the wording, not the numeric value that determines the slice size. The proportions change only if the underlying values or the data included in the chart change. After editing labels, check that the chart still shows the intended categories and values.

Related

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.