Google Sheets Chart Series Name: Meaning and Fixes

In Google Sheets, a chart series name is the label that identifies one set of plotted values, usually shown in the chart legend. Sheets normally gets that name from the column or row header included in the chart’s data range, so changing the source header is usually the way to rename a series.

What a chart series name means

A chart series is a group of related numbers that Sheets plots together. In a column chart, for example, each series may appear as a differently colored set of bars; in a line chart, it may appear as one line. The series name tells readers what that group represents, such as Revenue, 2025, or Product A.

The name is not the same as the chart title, an axis title, or a category label. A chart title describes the whole graphic. An axis title describes a scale, such as Months or Units sold. Category labels identify individual positions or groups along an axis, such as January, February, and March. A series name identifies a data set across those categories.

For instance, if column A contains months and columns B and C contain sales for two stores, the months are category labels, while the headers Store North and Store South are series names. Each store becomes a separate plotted series.

How Google Sheets assigns the name

When you create a chart from a rectangular range, Sheets interprets part of that range as labels and the rest as values. If the top row contains headings and is included in the range, Sheets can use those headings as series names. In the example above, including A1:C4 lets Sheets use B1 and C1 as the names for the two value columns.

To inspect how Sheets has read the data, double-click the chart to open the Chart editor, then select the Setup tab. The Data range shows the cells being considered. The Series section lists the plotted data ranges, and the chart setup options include Use row 1 as headers and Use column A as labels. Those options matter: if the header row is excluded or not treated as headers, Sheets may use a generic or unintended label rather than the wording you expect.

Series can also be arranged in rows instead of columns. If each row represents a series, use Switch rows/columns in the Setup tab. The headers that identify those rows can then serve as the series names. Whether rows or columns make more sense depends on how the source table is organized, not on a universal rule about chart type.

Change a chart series name

For a typical chart, edit the header cell in the source data and make sure the chart includes that cell as a header. This keeps the data table understandable as well as updating the chart label. For example, if the chart currently says Series 1 but the figures in B2:B10 are monthly costs, enter Costs in B1 and include B1:B10 in the chart’s data range.

Find the cell at the top of the relevant data column, or at the start of the relevant data row if your series are arranged horizontally.
Type the name you want, such as Online orders or 2025 actuals, and press Enter.
Double-click the chart and open Setup in the Chart editor.
Check the Data range and confirm that the header cell is included. Make sure Use row 1 as headers or the corresponding row-and-column arrangement is set correctly.
Check the chart legend. If the old name remains, verify that the plotted series is linked to the range you edited and that the chart is not using a different header row.

In the standard Google Sheets chart editor, the series is linked to the data range; its displayed name is generally derived from the range’s heading rather than typed into a separate rename box. If you need a different label, changing the appropriate source heading is the dependable method. If that heading is used elsewhere in the sheet, consider whether changing it will also affect formulas, filters, or other charts.

Choose a clear data layout

A tidy table makes series names easier to set and charts easier to maintain. Put one descriptive header above each value column, put category labels in the first column, and keep one record or time period per row. Avoid blank header cells, merged cells, and extra explanatory rows inside the selected data range when possible.

One series: A1 can contain Month, B1 can contain Orders, and the rows below can contain dates and order counts. Orders is the series name.
Several series: Use Month, Store North, and Store South as the three headers. The two store columns become separate series, while the first column supplies category labels.
Series in rows: Put a label at the start of each data row and categories across the columns. If the chart reads the data in the wrong direction, try Switch rows/columns rather than rebuilding the table immediately.

Headers should be concise but specific. Names such as Actual and Forecast are clearer than Column B and Column C, but adding units can help when the measure is ambiguous. If the chart is crowded, use short labels in the cells and explain abbreviations in a note near the chart rather than relying on a long legend entry.

Why a name is missing or incorrect

A generic label or an unexpected legend entry usually points to a mismatch between the selected range and the table layout. Check the following before changing chart styling:

The header is outside the data range. Expand the range to include the heading cell, not just the numeric values.
The header option is wrong. In Setup, check whether Sheets should treat the first row or first column as headers and whether the data is oriented by rows or columns.
The chart uses a different range. A chart may have been created from another table or may include extra columns. Review the Data range and each entry under Series.
The header cell is blank. Add a useful label instead of expecting Sheets to infer what the values mean.
The wrong cells were selected. A text cell within the selected values can affect how Sheets interprets the data. Keep headings separate from the numeric observations.
The legend is hidden. A missing legend does not necessarily mean the series has no name. In Customize, open Legend and choose a position if you want the labels displayed.

Also distinguish a label problem from a plotting problem. If a series is absent entirely, check whether its column or row appears in the chart’s Series list and whether the data range includes its values. If the series appears but has the wrong label, inspect the associated heading. Styling the legend will not repair an incorrect source range.

Series names, chart titles, and labels

These chart elements answer different questions, so changing one will not necessarily change the others. To change the overall chart title or an axis title, use Customize, then Chart & axis titles in the Chart editor. To change the legend’s location or appearance, use Customize, then Legend. To change the series name, edit the source heading and check the Setup range.

Data labels are different again: they display values or other information next to points, bars, or slices. They do not replace the series name. A chart can show a series name in its legend and numerical data labels on each bar at the same time, or it can omit the legend if the meaning is already clear from nearby text.

Some chart types make the distinction less obvious. A pie chart commonly uses category labels for its slices and may show a single value series, while a scatter chart uses an X-axis range and one or more Y-value series. In those cases, check the chart’s Setup options to see which ranges are serving as categories, axes, and series rather than assuming every visible label is a series name.

Google Sheets and Excel handle names similarly

Both Google Sheets and Excel can use source headers as chart series names, so a well-labeled data table is useful in either program. Their chart editors differ, however. In Google Sheets in a web browser, use the Chart editor’s Setup tab to review the data range, series, and header options, then edit the source header when you need a different series name.

In Excel for Microsoft 365 on Windows, select the chart and use Chart Design > Select Data. In the Select Data Source dialog, choose a series under Legend Entries (Series), select Edit, and set the Series name. Excel can use a cell reference for that name or accept text, depending on what you enter. That separate editing route is not the usual approach in Sheets, where the chart’s label normally comes from its data heading.

Frequently Asked Questions

How do I rename Series 1 in Google Sheets?
Edit the heading cell for the plotted values, then confirm that the chart’s data range includes that heading and treats it as a header. The legend should use the new heading.

Can I rename a series without changing the table heading?
Google Sheets generally derives a chart’s series name from its source heading rather than providing a separate series-name field in the standard chart editor. If you need the chart to show different wording, you can change the heading or create a separate, clearly labeled source range for that chart.

Why does my chart show Series 1 instead of my column name?
The chart may not include the heading cell, the header option may be off, or the selected range may not match the table. Check Setup, the data range, and the Use row 1 as headers setting.

How do I change the legend name but not the chart title?
Change the source header for the series. The chart title is edited separately under Customize > Chart & axis titles, so changing one does not normally require changing the other.

Can one chart have several series names?
Yes. Include a heading for each value row or column in the chart’s data range. Sheets can plot each data group as a separate series, with its own name in the legend when the legend is shown.

Why is my series name not showing on the chart?
The legend may be turned off, or the chart may not be using the expected heading. Check Customize > Legend to display the legend, then review Setup and confirm the heading is included in the chart’s source range.

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.