Excel Pivot Chart: Change Legend Label Names

To change a PivotChart legend label in Excel for Microsoft 365 on Windows, change the caption of the corresponding value field or PivotTable item: right-click the relevant PivotTable field or item, choose the appropriate field settings or rename its displayed label, and the chart updates with it. PivotChart legend names are connected to the PivotTable, so editing a chart series name through Select Data is generally not the way to rename them.

What a PivotChart legend label represents

A legend entry identifies a series in the chart. Its source depends on how the PivotTable is arranged. For example, if a PivotTable summarizes sales by month, with product categories placed in Columns, the chart may show one legend entry for each product. If the Values area contains both Sales and Units, the chart can instead show entries for those two measures.

That distinction matters because the same-looking legend text can come from different places. A label such as “Sum of Sales” is usually the caption of a value field. A label such as “Accessories” may be an item in a source-data field, such as Product. A chart’s legend title, if one is displayed, is different again: it describes the grouping field, while the individual legend entries name the plotted series.

Value-field caption: identifies a measure, such as Sum of Revenue.
Pivot item: identifies a category or field item, such as a region or product.
Legend title: may describe the series grouping, but is not the same as an entry in the legend.

Rename a value field used as a legend entry

When the legend shows a default caption such as “Sum of Revenue” or “Count of Orders,” change the value field’s custom name. This is the usual fix when a chart has multiple measures and each measure appears as a separate series.

Click a cell in the PivotTable that contains the value field. If necessary, select the PivotTable first so that its contextual ribbon tab appears.
Right-click a value or its heading and choose Value Field Settings.
In the dialog, enter the desired text in Custom Name, such as “Revenue” instead of “Sum of Revenue.”
Choose OK. The PivotTable heading and the related PivotChart legend entry should show the revised caption.

You can also edit the displayed value-field heading directly in the PivotTable in many layouts: select the heading cell, type the new caption, and press Enter. If Excel reports that the field name already exists, choose a distinct caption. For instance, if the source column is already named Revenue, “Revenue Total” avoids using the identical name. The custom caption changes the PivotTable display; it does not rename the source column in the original data.

Rename a category or item in the legend

If the legend lists categories such as “North,” “South,” or “Accessories,” the text usually comes from items in a row or column field. Find the same item in the PivotTable and edit its displayed label. Select the item’s label cell, type the preferred name, and press Enter. For example, changing “N.” to “North” in the PivotTable can change the matching legend entry in the PivotChart.

This is a PivotTable item caption, not a direct edit to the chart. It also does not necessarily change the underlying source value. If the workbook is refreshed or rebuilt, check whether the revised caption remains appropriate for the refreshed data. For a durable, consistent naming scheme across multiple PivotTables or reports, it is usually better to standardize the source data or create a helper column containing the preferred display names, then build or refresh the PivotTable using that field.

Before editing, confirm that you are changing the item that actually feeds the legend. A field in the Rows area may supply the chart’s category axis, while a field in the Columns or Legend (Series) area commonly supplies the separate series. The chart’s arrangement and chart type affect what is shown, so compare the PivotTable layout with the legend rather than guessing from the label alone.

Change labels in the source data for a consistent result

For a one-off presentation, a PivotTable caption edit may be enough. For a workbook that is refreshed regularly, reused by colleagues, or contains several reports, edit or map the labels in the source data instead. For example, if source rows contain “Web,” “Store,” and “Phone,” but the report should say “Online,” “Retail,” and “Telephone,” create a cleaned category column with those names and use it in the PivotTable.

A helper column is useful when the original values need to remain intact for auditing or other analysis. Keep the original field, add a clear display field such as “Channel for report,” and use the display field in the PivotTable. This makes the intended labels explicit and reduces the chance that a manual caption edit will be lost or become confusing when new source items arrive.

After changing source values or adding a helper field, refresh the PivotTable using PivotTable Analyze > Refresh, or right-click the PivotTable and choose Refresh. If new rows or columns are not included, the PivotTable’s source range may need to be expanded or converted to an Excel Table. Refreshing updates the PivotTable from its source; it does not guarantee that every manually renamed item caption will match a revised source label.

Why Select Data may not let you edit a PivotChart legend

For an ordinary chart, Excel’s Select Data Source dialog can be used to edit series names. A PivotChart is different because its plotted series are controlled by the associated PivotTable and its field layout. As a result, the series-name controls may be unavailable or changes may not behave like they do for a standard chart. Change the value-field caption or the PivotTable item instead.

This connection is useful: filtering a PivotTable or moving fields between areas can update the PivotChart without manually rebuilding its series. It also means that chart-specific workarounds may be temporary or unavailable. If you need complete control over independent series names, chart ranges, or data selection, consider making a regular chart from a separate summary range rather than trying to detach the PivotChart’s labels.

Tell which label needs changing

Use the visible wording and the PivotTable layout to identify the label source. A legend that reads “Sum of Sales” or “Average of Margin” points to a value field. A legend that lists actual names, locations, or product types usually points to items in a category field. If the chart has only one series, Excel may not display a legend at all; turning the legend on will not create a useful series name if the chart has no meaningful grouping.

If the label begins with an aggregation such as Sum, Count, or Average, inspect the value field’s settings.
If the label is a category found in the source column, locate that item in the PivotTable and decide whether to rename it there or in the source.
If you are trying to rename “Legend” itself, distinguish the legend box from its entries. The entries are the series names; the legend box is a chart element.

For a clearer chart, consider whether the field arrangement is right as well as whether the wording is right. Moving a field into or out of the Columns or Legend (Series) area can change which items become series. A renamed label cannot fix a chart whose series are grouped in the wrong way.

Common issues and ways to resolve them

The chart label did not change: check that the edited PivotTable belongs to that PivotChart, and that you changed the actual value field or series item rather than a nearby heading.
The caption is rejected: use a different name from the source field and other PivotTable field captions. Excel requires field names to be distinguishable.
The old text returns after refresh: inspect the source data and the field’s items. Use a source-data cleanup or helper column when the name needs to remain standardized.
New categories appear with inconsistent wording: standardize spelling, spaces, and abbreviations in the source. PivotTables treat distinct text values, such as “North” and “North ” with a trailing space, as separate items.
The label looks cut off: widen the chart or legend area, reduce the font size, or use a concise caption. A correct label can still be hard to read when the chart is crowded.

When troubleshooting, change one thing at a time and check both the PivotTable and chart. If the PivotChart is filtered, a renamed item may not be visible until the filter includes it. Likewise, if the chart has been copied or the workbook contains multiple PivotTables, verify which report is linked to the chart before making broader source-data changes.

Excel on Mac and Excel for the web

The core principle is the same in Excel for Microsoft 365 on Mac: a PivotChart’s series names come from its PivotTable, so change the relevant value-field caption or item label in the PivotTable. The ribbon layout and contextual tab names can differ slightly by Excel release and window size. If the Windows path is not visible, select the PivotTable and look for its PivotTable tools, or use the right-click menu on the relevant value field.

Excel for the web supports many PivotTable and chart tasks, but available commands can vary with the workbook and current web features. If a setting such as Value Field Settings is not available in the browser, open the workbook in the desktop Excel app to make the change. Afterward, save the workbook and confirm the chart label in the version used by the report’s audience.

Frequently Asked Questions

Can I rename a PivotChart legend entry without changing the PivotTable?
Usually not in the same way as a normal chart. PivotChart series are controlled by the PivotTable, so change the related value-field caption or item label. For independent chart labels, create a regular chart from a separate summary range.

How do I change “Sum of” in a PivotChart legend?
Right-click a value in the PivotTable, choose Value Field Settings, and enter a shorter name in Custom Name. The PivotChart should use that caption for the corresponding series.

Will renaming a PivotTable item change my original data?
A manual PivotTable item caption changes what the report displays, not necessarily the value stored in the source rows. Change the source data or use a helper display column if the revised wording should be consistent throughout the workbook.

Why does my PivotChart show no legend?
A chart with one series may not need a legend, and Excel may omit it. Select the chart and use the Chart Elements button to turn on Legend if available; if there is only one series, a clear chart title or data labels may communicate the measure more effectively.

Why does my custom label disappear after refreshing?
A refresh updates the PivotTable from its source, and new or changed source items can affect displayed captions. Standardize the source field or use a helper column for stable report names, then refresh and check the PivotTable and chart.

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.