How to Change Legend Names in an Excel PivotChart

To change a legend name in an Excel PivotChart, rename the field caption or item that supplies the legend entry in the associated PivotTable, then refresh the chart if needed. For a value-series name, select its value heading in the PivotTable or use Value Field Settings; for a legend entry representing an item such as a product or region, change that item in the PivotTable or its source data.

What a PivotChart legend name represents

A PivotChart is connected to a PivotTable, and its legend is generated from the fields and items in that report. That connection is the key difference from an ordinary chart: a PivotChart does not give you complete freedom to rename a series independently of the PivotTable that controls it. Its legend may contain value-series captions, item names from a field placed in the Legend (Series) area, or both.

For example, imagine a PivotTable that summarizes sales by month and has separate series for Online and Store. If the Values area contains Sum of Revenue, that caption identifies the plotted measure; Online and Store are items from the sales-channel field. Those are different kinds of labels, so the right way to change one depends on which label you mean.

Value-series caption: A name such as Sum of Revenue or Count of Orders, usually created from a field in the Values area.
Field item: A name such as Online, Store, East, or West, usually created by placing a categorical field in Legend (Series).
Chart title: The text above the chart. Editing it does not rename a legend entry.

Rename a value field in the PivotTable

In Excel for Microsoft 365 on Windows, the quickest option is often to edit the value heading directly. Find the heading in the PivotTable that corresponds to the series, click its cell, type the preferred caption, and press Enter. For example, change Sum of Revenue to Revenue. If the PivotChart uses that value field, its legend should reflect the updated caption.

You can also use the field settings dialog, which is useful when you want to confirm exactly which measure you are renaming:

Click a number in the relevant value column of the PivotTable.
Right-click and choose Value Field Settings. Depending on the selected cell and Excel build, the same command is available from the PivotTable Analyze tab in the ribbon.
In the dialog, enter a new label in Custom Name, then select OK.

Excel may reject a custom name that exactly duplicates another field name in the PivotTable. If that happens, choose a distinct caption, such as Revenue Total rather than Revenue when Revenue is already used as a field name. The displayed caption can be more reader-friendly than the default Sum of or Count of wording, while the calculation itself remains the same.

Changing the custom name changes the caption, not the aggregation. If the field is summarized by Sum, renaming it Average Revenue does not convert the calculation to an average. To change how the values are calculated, use Value Field Settings and select a different option under Summarize Values By; then choose a caption that accurately describes the result.

Change a legend entry that is a field item

If the legend lists categories such as Online and Store, those labels come from the items in a PivotTable field, not from the Values field caption. To change one label for this report, locate the corresponding item label in the PivotTable, select its cell, type the replacement text, and press Enter. For example, you might display Online as Web sales. The linked PivotChart will generally use the revised item label.

This is a presentation-level rename in the PivotTable. The underlying source records may still contain Online, so another PivotTable built from the same data can continue to show the original text. If the wording should be consistent across reports, charts, and future refreshes, change the value in the source data instead. Then refresh the PivotTable using PivotTable Analyze > Refresh, or right-click the PivotTable and choose Refresh.

For a durable source-data change, edit the relevant category values in the source table, keeping spelling and capitalization consistent, and refresh the PivotTable. If the report has grouped items, calculated items, or several PivotTables sharing a cache, check the results in each report: a change can affect more than the one chart you are looking at. When an old and new category both appear after a source edit, inspect the source rows for inconsistent spellings and refresh again.

Find which field controls the legend

If it is not clear where a label comes from, inspect the PivotTable Fields pane. Click the PivotTable, then open PivotTable Analyze > Field List if the pane is not visible. In the pane, fields placed in Legend (Series) generate category names across the chart legend. Fields in Values generate the plotted measures and their value captions. A field in Axis (Categories) usually supplies the labels along the chart’s horizontal axis, not the legend.

For instance, if Revenue is in Values and Channel is in Legend (Series), Revenue is the value caption and Online and Store are the item labels. If you move Channel to Axis (Categories), those same names may appear along the axis instead. The exact layout and resulting legend depend on the chart type and the fields in the report. Moving a field changes the chart’s organization, so do that only when you intend to change what the chart compares.

A helpful check is to compare the legend with the field buttons and headings in the associated PivotTable. If the legend says Sum of Revenue, look for the corresponding value heading. If it says East or West, look for the field containing those items. This avoids editing the chart title or an unrelated field caption.

Why the usual chart-series editing method may not work

With a standard chart, you can often select Chart Design > Select Data and edit a series name directly. PivotCharts are different: their series and categories are controlled by the associated PivotTable, so ordinary chart data-source editing is restricted or unavailable for changing the PivotChart’s underlying field arrangement. Renaming the PivotTable caption or item is the appropriate route when you want the PivotChart to stay connected and interactive.

You can still use chart formatting commands to change the legend’s appearance, position, or visibility. Those commands do not change the text’s source. Similarly, selecting a legend label and typing over it is not a reliable way to rename a PivotChart series; the label is controlled by the report and can return to its field-derived name when the report changes or refreshes.

If you need series names that are completely independent of PivotTable labels, make a separate, static chart from a normal data range instead. One approach is to copy the summarized PivotTable results and paste values into a separate area, then insert a regular chart from that range. The chart can then use the usual Select Data controls, but it will not automatically respond like a PivotChart when you rearrange fields or filter the PivotTable. Treat the copied data as a snapshot and update it when the report changes.

Refreshes, filters, and common naming problems

A refresh updates a PivotTable from its source, but it does not mean every type of name behaves in precisely the same way. A custom value caption is a PivotTable setting; a manually edited item label is a report label; and a source-data edit changes the underlying category text. When a label reverts or an unexpected name appears, identify which of those three you changed before repeating the edit.

The legend still says Sum of Revenue: Confirm that you changed the heading for the value field used by this chart, rather than the chart title or another measure.
Excel will not accept the custom name: Try a distinct caption that does not duplicate a PivotTable field name.
The new item appears alongside the old one: Check for source rows using both spellings, then refresh the PivotTable.
The legend does not show the item you renamed: Check whether that item is filtered out or whether the chart uses a different field.
The chart changes after rearranging fields: The legend is field-driven; inspect the Legend (Series) and Values areas again.

Also distinguish a blank-looking label from a missing series. A blank source value may be represented as a blank item or handled according to the PivotTable layout and chart settings. Rename or clean the source value if the blank category is not meaningful, then refresh. Do not rename a different category simply to hide an unwanted blank.

Windows and Mac notes

The instructions above use Excel for Microsoft 365 on Windows. Excel for Mac also supports PivotTables and PivotCharts, but ribbon labels and the location of field-list or value-field commands can vary with the app version and window layout. On Mac, select the PivotTable or a value in it and look for the PivotTable contextual tab or right-click menu; use the value-field settings command to edit the custom caption. The important distinction remains the same: edit the value caption for a measure or the item label/source text for a category.

Excel for the web can open and work with many PivotTables, but available PivotTable editing features may differ from the desktop app. If a command such as Value Field Settings or the required item-label editing is not available in your browser version, open the workbook in the desktop Excel app to make the change. Menu names and feature availability can change over time, so use the commands visible in your current version rather than relying on a keyboard shortcut for this task.

Choose a naming approach that fits the report

For a quick improvement to one chart, changing a value field’s custom caption is usually the simplest option. It keeps the PivotChart interactive and makes a default label such as Sum of Revenue easier to read. For a category label used only in one report, editing the PivotTable item can be convenient. For consistent names across multiple reports, correct the source data and refresh so the source itself has the intended wording.

Before choosing, consider who maintains the workbook and how often its data changes. A manually edited item label can be less obvious to a future editor than a clear source value. Conversely, changing source data may affect other reports or downstream processes, so check what else uses that data. Keep labels concise enough to fit in the chart legend, and use wording that describes the measure accurately rather than implying a different calculation.

Frequently Asked Questions

Can I rename a PivotChart legend entry without changing the PivotTable?
A PivotChart’s legend is controlled by its PivotTable, so a lasting rename normally requires changing the value caption or item label there. For independent names, create a regular chart from a separate data range, understanding that it will not behave like the PivotChart when you rearrange or refresh the report.

How do I remove Sum of from a PivotChart legend?
Change the value field’s Custom Name in Value Field Settings, or edit its heading in the PivotTable. Use a name that is not an exact duplicate of another field name. This changes the displayed caption, not the calculation.

Why does my PivotChart legend show product names instead of a measure name?
The product field is likely in Legend (Series), so its items become legend entries. The measure in Values may be represented elsewhere in the chart layout. Check the field placements in the PivotTable Fields pane to see which field supplies each label.

Will a renamed legend label survive a PivotTable refresh?
A custom value caption is a PivotTable setting, while a manually edited item label and a source-data edit are different kinds of changes. If a category name needs to remain consistent as data is refreshed or reused, update the source text and refresh, then verify the report. The precise result can depend on the PivotTable setup.

Can I change the legend text in Excel for the web?
Some PivotTable editing commands may not be available in every web version. If the browser does not offer the needed value-field or item-label controls, open the workbook in desktop Excel for Microsoft 365 and make the change in the associated PivotTable.

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.