Google Sheets Chart Legend Labels: Edit and Fix

In Google Sheets, chart legend labels usually come from the headings in the chart’s source data: edit the relevant header cell to rename a legend entry. To change how the legend looks or where it appears, select the chart, open Edit chart, then use Customize > Legend.

What chart legend labels mean

A chart legend identifies the data series represented by the chart’s colors or symbols. In a column chart comparing monthly sales, for example, the legend might show the names of three product lines. Each name is paired with the corresponding colored columns, making it easier to distinguish the series.

Legend labels are not the same as a chart title, axis title, category labels, or data labels. A chart title describes the whole chart; axis titles describe the values or categories along an axis; and data labels display values or other details next to individual bars, points, or slices. The legend instead explains which visual style belongs to each series or category.

That difference matters when a chart looks confusing. If the legend says “Series 1,” the issue is usually the source range or its headers—not the legend’s font settings. If labels appear next to every bar, those are data labels, which are controlled separately from the legend.

How Sheets gets labels from your data

For a typical chart, Sheets reads the data range and interprets its first row or column as headings and category labels. Imagine a table with months in column A and product names in row 1. The product names are the series headings, while the months identify the categories along the horizontal axis. The legend uses the series headings.

When you create a chart, Sheets often recognizes headers automatically. In the chart editor’s Setup tab, options such as Use row 1 as headers and Use column A as labels tell the chart how to interpret the selected range. The exact row or column shown in an option can depend on the range you selected.

If you switch the chart’s rows and columns, the interpretation changes: data that was treated as multiple series may instead become categories, or vice versa. This can change the legend entries without changing any cell contents. For charts built from rows rather than columns, the series names may come from the row labels instead of the top-row headings.

Rename a legend label

For most standard charts, the reliable way to rename an entry is to change the source heading that supplies it. You do not usually type a replacement label directly into the legend itself.

Click the chart, then open its three-dot menu and choose Edit chart. You can also double-click the chart to open the chart editor.
In Setup, check the chart’s data range and confirm which row or column supplies the series names.
Find the corresponding heading cell in the sheet and replace its text. For example, change Product A to North region if that is the accurate name for the series.
Return to the chart and confirm the updated legend entry. Sheets generally updates the chart when its source data changes.

Keep the heading clear and concise because long names can make a legend crowded. If the heading is also used elsewhere in the sheet, remember that changing it changes the underlying table label as well as the chart legend.

Use custom names without changing the original table

Sometimes the original column header is important for a report, formula, or data import, but the chart needs a shorter or more reader-friendly name. In that case, create a small helper range with the same data and the chart-specific headings you want. Build the chart from that range, or adjust its data range in Setup so it uses the helper table.

For example, a source table might use the technical headings revenue_actual_usd and revenue_forecast_usd. A helper range can use Actual and Forecast as its first-row headings while referring to the original values. This separates chart presentation from the source table’s naming convention. Make sure the helper range stays aligned with the correct values, especially if rows are added or the source data changes.

A formula can also produce a heading in a helper cell, but the result shown in the cell is what the chart uses. If you use formulas to build a dynamic table, verify that the headings remain unique and meaningful when the source changes.

Format or move the legend

To change the legend’s appearance, select the chart and open Edit chart > Customize > Legend. The available controls include the legend’s position, font, font size, format, and text color. Depending on the chart type and space available, you can place the legend above, below, to the left, or to the right of the chart, or inside the chart area. Choosing None hides it.

Formatting affects the legend as a whole; it does not rename individual entries or change which series a color represents. To change series colors, use the chart editor’s Customize options for the relevant series. A useful sequence is to set the series colors first, then choose a legend position that leaves enough room for the names.

Use a bottom or right-side legend when readers need to compare several series.
Try a top legend for a wide chart with only a few short names.
Hide the legend when there is only one series and its identity is already obvious, or when labels elsewhere explain the colors.
Increase font size for readability, but check that longer entries do not crowd the plot.

Pie charts and category names

Pie charts are a common source of confusion because their legend usually lists categories, such as departments or expense types, rather than separate data series. If a pie chart should show Rent, Food, and Transport, those names need to be present in the cells Sheets is using for category labels. Edit those source cells to correct the legend wording.

Pie charts also have a separate setting for what appears on or near each slice. In Customize > Pie chart, the Slice label option controls whether the chart displays values, percentages, labels, or another available choice. That setting is distinct from the legend: changing a slice label does not necessarily rename the legend entry, and changing the legend’s font does not change the text on the slices.

Fix missing, repeated, or generic labels

If the legend is missing or its entries do not match expectations, check the chart setup before changing formatting. These are common causes and fixes:

A generic name such as “Series 1” appears: Check whether the data range includes the intended header row or column. In Setup, confirm the header option is selected when appropriate, then check that the heading cell contains useful text.
The legend is absent: Open Customize > Legend and check whether its position is set to None. If the legend is enabled but still not visible, widen the chart or choose another position.
An unwanted entry appears: Review the chart’s data range and the series listed in Setup. The range may include an extra column, a notes column, or data that should not be plotted.
Names appear as categories instead of series: Check whether the data is arranged by rows or columns and whether Switch rows/columns is appropriate. Also verify which row and column Sheets treats as headers and labels.
A name is blank or misleading: Inspect the source heading cell, including cells that contain a formula returning an empty string or unexpected text. Correct the source or provide a more useful header.

When the chart has many series, also consider whether a legend is the best way to explain it. A long list may be difficult to scan even if every label is technically correct. Reducing the number of plotted series, splitting the chart, or using clearer category labels can make the comparison easier to understand.

Legend labels versus Excel charts

Google Sheets and Microsoft Excel use the same basic idea: a chart’s legend identifies plotted series, and series names commonly come from source headers. In both programs, changing the source heading is a straightforward way to change the displayed name. Their chart editors and menu layouts differ, however, so instructions for one program should not be assumed to match the other.

In Sheets, use the chart editor’s Setup and Customize tabs. Excel for Microsoft 365 on Windows typically provides chart-specific commands on the ribbon and a Format Legend pane; that is not the Sheets menu path. If you move a chart or workbook between the programs, check the data range, series names, and formatting after conversion, as chart appearance and some settings may not transfer identically.

Frequently Asked Questions

Can I rename a Google Sheets legend label without changing the source data?
Usually, not by editing the legend entry directly. Create a helper range with the labels you want and use that range for the chart, leaving the original table unchanged.

How do I change the color beside a legend label?
Select the chart, open Edit chart > Customize, and select the relevant series in the series controls. Change that series’ color; the legend swatch follows the chart’s series styling.

Why does my legend say “Series 1”?
The chart may not include the heading cell, or Sheets may not be treating that row or column as a header. Check the data range and the header options under Setup, then make sure the source heading contains the desired text.

Can I remove the legend but keep the chart?
Yes. Open Edit chart > Customize > Legend and set its position to None. This hides the legend without deleting the chart or its data.

How do I show names on pie slices as well as in the legend?
Keep the legend enabled under Customize > Legend, then choose the desired option under Customize > Pie chart > Slice label. The exact presentation depends on the selected chart settings and available space.

Will changing a header update a chart automatically?
For a chart linked to that source range, Sheets generally reflects edits to the heading in the chart. If it does not, confirm that the chart uses the cell you changed and that the intended range is still selected.

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.