Pivot Chart Add Legend: How to Show and Format It in Excel

To add a legend to a PivotChart in Excel for Microsoft 365 on Windows, select the chart, then choose Chart Design > Add Chart Element > Legend and select a position such as Right, Top, Left, or Bottom. If the legend is already there but shows the wrong items, check the PivotChart’s Legend (Series) field: the legend displays the names of the plotted series, not the chart’s field buttons.

What a PivotChart legend shows

A chart legend is the key that connects a visual mark—such as a line, column color, or pie-slice color—to the data series it represents. For example, a PivotChart showing monthly sales for three product lines can use three differently colored lines; its legend identifies which line belongs to each product line. The chart title describes the overall subject, while the legend explains the series within the chart.

PivotCharts are connected to PivotTables, so their plotted data and labels are controlled through pivot fields as well as ordinary chart settings. In the PivotChart Fields pane, fields can be assigned to areas such as Axis (Categories), Legend (Series), Values, and Filters. A field placed in Legend (Series) can split the values into separate series, which usually creates corresponding legend entries.

What the legend represents depends on the chart type and field arrangement. In a column chart, it commonly identifies each column series. In a pie chart, the slices are categories within a single data series, so the legend may identify the slice categories instead. A legend does not show every field in the PivotTable; it identifies the plotted data that needs explanation.

Add or remove the legend

Use the chart’s contextual ribbon rather than trying to add a legend from the PivotTable itself. The chart must be selected for the Chart Design tab to appear. These steps apply to Excel for Microsoft 365 on Windows:

Click the PivotChart. If you click the PivotTable instead, the PivotChart-specific chart commands will not be available.
Open Chart Design on the ribbon.
Select Add Chart Element > Legend.
Choose a location, such as Right, Top, Left, or Bottom. Choose More Legend Options to open the formatting pane for additional settings.

To remove it, select the chart and choose Chart Design > Add Chart Element > Legend > None. You can also select the legend itself and press Delete. Deleting the legend does not remove the series or values from the chart; it only hides the key that names them. If you delete the wrong chart element, use Undo immediately.

Another route in many Windows desktop builds is to select the chart, click the Chart Elements button (the plus sign beside the chart), and turn on Legend. The button offers position choices through its arrow. The Chart Design route is easier to follow when the plus button is not visible or when you need the full formatting options.

Choose a useful legend position

Excel offers several standard positions, and the best one depends on the chart’s shape, the number of series, and the labels. A legend on the right is familiar and works well when the chart is wide enough to accommodate it. A legend at the bottom can preserve horizontal plotting space, which may help a chart with long category labels. A top legend can be convenient for a compact chart, while a left legend is useful when that placement balances the layout.

After moving the legend, check that the plot area—the area where the data is drawn—has not become too small. A chart with many series may need more room for the legend than a chart with two or three. You can resize the overall chart, shorten series names where appropriate, or reposition the legend. Avoid making the chart so crowded that labels become difficult to read.

For instance, suppose a PivotChart compares quarterly revenue for six regions. A right-side legend makes the region colors easy to scan, but it may squeeze the columns if the chart is narrow. Moving the legend to the bottom can give the plot more width, although a long row of region names might wrap or take up substantial vertical space. Preview both layouts at the size where people will actually read the report.

Control which items appear in the legend

If the legend is visible but does not include the groups you expect, inspect the field layout before changing chart formatting. Click the chart and open the PivotChart Analyze tab, then choose Field List if the PivotChart Fields pane is hidden. Look at the field in Legend (Series). Moving a suitable field into that area can divide the chart into series; moving it out can combine those series or change the chart’s organization.

For example, if a PivotChart plots sales by month but has no separate series for product category, drag the Product field into Legend (Series). The chart can then display a separate series for each product, and the legend identifies them. The exact result depends on the chart type and the available values. Putting a field in Axis (Categories) instead changes the category labels along the chart’s axis; it does not perform the same job as placing it in Legend (Series).

PivotChart field buttons are not the legend. Buttons such as a field name or filter control may appear over the chart and let viewers filter or rearrange pivot fields. To hide them in Excel for Microsoft 365 on Windows, select the chart and choose PivotChart Analyze > Field Buttons > Hide All. Hiding field buttons does not turn the legend off, and adding a legend does not hide field buttons. They are separate chart elements with different purposes.

Format legend text and series names

To adjust the legend’s appearance, select it and open its formatting options. You can use Chart Design > Add Chart Element > Legend > More Legend Options, or right-click the legend and choose Format Legend. The pane provides position and layout options; the available controls can vary with the chart type and the selected element. For text size, color, or font emphasis, select the legend text and use the Home tab’s font controls. Keep the lettering large enough to read at the chart’s final display size.

Series names in a PivotChart generally come from the values field or the pivot-field items that make up the series. If a series is called “Sum of Sales” and that is not helpful, change the value field’s custom name in the associated PivotTable: right-click a value in that field, choose Value Field Settings, enter a clearer Custom Name, and confirm. The PivotChart can then use the updated name. A custom name must be distinct from existing field names in the PivotTable.

When the legend entries are categories such as region or product, their wording comes from the field items and ultimately from the source data or the PivotTable’s displayed items. Correct the source labels or the relevant pivot item names if the legend contains misspellings or unclear wording, then refresh the PivotTable if the source data changed. PivotCharts do not behave exactly like ordinary charts: directly editing series names through the usual Select Data workflow may be unavailable or constrained because the chart is linked to its PivotTable.

Common legend problems and fixes

No Legend option appears: Make sure the chart—not the PivotTable or a chart title—is selected. Then check the Chart Design tab. If the ribbon is minimized, expand it or use the chart’s plus button where available.
The legend is present but blank or confusing: Check whether the plotted series have meaningful names and whether the intended field is in Legend (Series). A field in Filters or Axis (Categories) will not necessarily create the series breakdown you want.
The legend disappears after a change: Reopen Chart Design > Add Chart Element > Legend and choose a position. Also check whether the chart was resized or a chart layout was applied that changed which elements are displayed.
There are too many entries: Filter the relevant pivot field to show only the items needed for the question, or redesign the chart to compare fewer series. A long legend can be technically correct but still make the chart hard to interpret.
The colors are difficult to tell apart: Use a chart style or format series with clearer contrast, and do not rely on color alone if the chart will be printed in grayscale or read by people with color-vision differences. Direct labels can sometimes make a small chart easier to understand.

Filtering a PivotChart can change which series or categories are shown, so its legend may change along with the plotted data. That is expected behavior, not a separate legend error. If the chart is meant to compare all groups consistently, check its filters before sharing or exporting it.

PivotChart legends versus ordinary chart legends

The basic display controls are similar for PivotCharts and regular charts: both can show a legend at the top, bottom, left, or right, and both support formatting. The key difference is the source of the chart’s structure. A regular chart usually points directly to a cell range, and its series can be adjusted through chart data settings. A PivotChart follows the associated PivotTable, so its fields, filters, and refresh behavior shape the series and categories.

This connection is useful when a report needs interactive filtering: a viewer can filter pivot fields and see the chart update. It can also be limiting when someone expects to manually rename or rearrange every chart series independently of the PivotTable. For a PivotChart, change the pivot layout or field names first; use chart formatting for appearance and placement. If you need chart series that are entirely independent of pivot-field rules, a regular chart based on a prepared cell range may be a better fit.

Excel for Mac and Excel for the web

In Excel for Mac, select the PivotChart and use the Chart Design tab’s Add Chart Element > Legend controls when available. Ribbon placement and wording can vary somewhat by Mac release, but the chart element is still managed from the selected chart. The PivotChart Fields pane may also be opened or displayed differently depending on the ribbon layout. The core distinction remains the same: use chart commands to show or position the legend, and use pivot fields to change what the legend represents.

Excel for the web has chart editing controls, but options and the ribbon layout can differ from the Windows desktop app, and some PivotChart editing capabilities may be limited. If you cannot find a particular legend or PivotChart field command in the browser, open the workbook in the desktop app and make the change there. Afterward, confirm that the chart still displays the desired legend when viewed in the browser.

Frequently Asked Questions

Can I add a legend to a PivotChart?
Yes. Select the PivotChart, then choose Chart Design > Add Chart Element > Legend and select a position. The legend identifies the chart’s series or, for some chart types, its categories.

Why does my PivotChart have no legend?
It may have been set to None, or the current chart layout may not display it. Select the chart and choose a legend position from Chart Design > Add Chart Element > Legend. If the entries are still missing or unhelpful, inspect the PivotChart Fields pane and its Legend (Series) area.

How do I change the names in a PivotChart legend?
For a value series, change its custom name through Value Field Settings in the associated PivotTable. For category or item names, update the source labels or the relevant pivot item names, then refresh if the source data changed.

How do I hide the filter buttons without removing the legend?
Select the chart and choose PivotChart Analyze > Field Buttons > Hide All. Field buttons and the legend are different elements, so hiding the buttons leaves the legend in place.

Can a PivotChart show a legend at the bottom?
Yes. Select the chart, then choose Chart Design > Add Chart Element > Legend > Bottom. Check the chart at its final size, since a long legend can take up space or wrap beneath the plot.

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.