Add a Series to a Google Sheets Chart: Steps and Tips

To add a series to a chart in Google Sheets, open the chart editor, choose Setup, and select Add series under the Series section. Then choose the cells containing the new data and click OK or press Enter; Sheets adds that range as another plotted data set.

What a chart series means

A series is a set of related values that Google Sheets plots together. In a column chart, each series commonly appears as a group of colored columns; in a line chart, it is usually a line. For example, a table with months in column A, actual sales in column B, and sales targets in column C can show Actual and Target as two series, with the months serving as the horizontal-axis labels.

Series are different from categories. In that example, each month is a category, while the actual and target columns are series. Adding another series therefore adds another measure to compare, not another month or label along the axis. This distinction helps diagnose a chart that shows the wrong comparison after data is selected.

Google Sheets charts can plot several series, but the useful number depends on the chart type and how easily readers can distinguish them. Two or three lines are often readable; a chart with many similar lines or dozens of columns may be harder to interpret than a summary or a different chart design.

Add a series in the chart editor

Click the chart in the sheet. Open its three-dot menu and choose Edit chart, or double-click the chart to open the chart editor.
In the chart editor sidebar, select the Setup tab.
Find Series and click Add series.
In the range picker, select the cells for the new data, including the heading if the column has one. You can also enter a cell range in the range field.
Confirm the range. Check that the new series appears in the Series list and that the chart displays the data as intended.

For instance, if months are in A2:A7, revenue is in B2:B7, and expenses are in C2:C7, selecting C1:C7 adds Expenses as a series when C1 contains its heading. If the chart already uses the months as its labels and Revenue as its first series, Expenses will appear alongside Revenue. Including the heading usually helps Sheets identify the series name; if the chart labels are not right, check the header and label settings described below.

The chart editor updates the chart as you work. You can close the sidebar when you are finished; the chart remains on the sheet, and you can reopen its editor later to change the ranges or styling.

Choose the correct data range

A series range should include the numeric values you want to plot and, where practical, the heading cell that names them. Keep the values in one column or one row, depending on how the source table is organized. If you select a range that includes the category labels as well as the values, Sheets may interpret the labels as another series or infer the chart structure differently than you expect.

Ranges do not have to be next to the chart’s existing data. In the range picker, choose cells in another part of the current sheet or another sheet in the same spreadsheet. For a tab named Monthly Sales, a range can be written with the sheet name and an exclamation mark, such as ‘Monthly Sales’!C1:C7. The apostrophes around a tab name with spaces are part of the range notation.

When the new data has a different set or order of categories, check that its values still line up with the existing chart labels. A chart comparing monthly revenue and expenses should use values for the same months in the same sequence. If revenue covers January through June but the added range covers February through July, Sheets may plot the values against the existing category positions rather than infer the intended month-by-month match. Align the tables before comparing them.

For ongoing reports, use a range that leaves room for expected new rows, or update the chart’s data range when new observations are added. A range that ends at row 20 will not necessarily include data later entered in row 21. Whether an edit or inserted row is picked up automatically depends on how the source range changes, so confirm the chart after extending a table.

Check headers, labels, and data orientation

Sheets tries to infer which cells are headers and which are labels, but it can make an unhelpful choice when the selected range is ambiguous. In the chart editor’s Setup tab, look for options such as Use row 1 as headers and Use column A as labels. The exact options shown can depend on the selected data and chart. Turn on the header option when the first row names the series, and use the label option when the first column contains categories such as dates, product names, or locations.

If your data is arranged horizontally, a row may be a series rather than a column. Use the chart editor’s Switch rows/columns option to tell Sheets to treat rows as series and columns as categories, or the reverse. For example, a table with product names across the top and quarters down the first column may need a different orientation from a table with quarters across the top and product names down the side.

After switching orientation, inspect both the legend and the horizontal axis. If the legend shows month names when you expected product names, or the axis shows product names when you expected months, the chart is using the opposite arrangement. Switching orientation changes how the selected table is interpreted; it does not rearrange or rewrite the source cells.

Pick a chart type that suits the added series

Adding a series does not guarantee that its values will be easy to compare. If the existing chart is a line chart, another time-based measure may fit naturally. A column chart can work well for comparing values across a small set of categories. A scatter chart is designed for pairs of numeric values and uses an x-axis range, so adding a series there is not always the same as adding another category-based column.

Before changing the chart type, ask what the reader should compare. If both series use the same unit and similar scales, plotting them together makes direct comparison easier. If one series is in dollars and another is a percentage, a single scale may make one series look nearly flat. Depending on the chart type and available settings, Google Sheets may let you assign a series to a right axis through Customize > Series and the Axis control. Use a second axis sparingly and label the chart clearly, because two scales can make visual differences easier to misread.

Some chart types do not present multiple series in the same way. A pie chart, for example, is intended to show parts of a whole from one set of values, not to compare several measures as separate lines. If the added series produces an unexpected or unhelpful result, select another chart type in Setup rather than assuming the range is broken.

Customize the new series

To distinguish the added data, open the chart editor’s Customize tab and expand Series. If the chart contains multiple series, use the series selector to choose the one to format. Depending on the chart type, available options can include color, line thickness, point shape, data labels, and axis assignment. The options vary by chart type, so a setting available for a line may not be available for a pie slice or column.

Use the heading to give the series a useful legend name, then choose a color that contrasts with the existing series and remains readable against the chart background. For a line chart, distinct line colors and point markers can help when lines cross. For a column chart, contrasting fills help readers identify each group. Avoid relying only on very similar shades, especially if the chart will be printed or viewed by people with color-vision differences.

Data labels can make exact values visible without requiring a reader to hover over a point, but labels on every value can crowd a chart. Consider enabling them when the chart has few data points or when the values are central to the task. For a dense time series, a clear axis and a concise legend may communicate the pattern better than a label on every point.

Common problems and fixes

The series is missing: Reopen Setup and confirm that the range appears under Series. Check that the range contains the intended cells and that the chart type can display another series.
The legend says Series 2 or shows the wrong name: Include the header cell in the selected range, or correct the header setting. You can also rename the heading in the source table and check whether the chart legend updates.
Values appear as zero or are ignored: Check whether the cells contain numbers rather than text that only looks numeric. Imported values with stray spaces, currency symbols entered as text, or error values may not plot as expected. Correct the underlying cells and review the chart.
The chart uses the wrong labels: Check Use column A as labels, the header option, and Switch rows/columns. Make sure category labels and series values are in the intended rows or columns.
The new series looks flat: Compare its scale and units with the existing series. A much smaller range can be difficult to see on the same axis. Consider a suitable chart type or, where supported, a clearly labeled right axis rather than changing source values just to alter appearance.
New rows do not appear: Review the chart’s selected data range and extend it to include the added rows. Do not assume that typing below the original range automatically expands every chart.

When a chart changes unexpectedly, inspect the source range before rebuilding the chart. A small correction to the selected cells, labels, or orientation is usually enough. Keeping a clean header row and a consistent table structure also makes later additions easier to manage.

Frequently Asked Questions

Can I add a series from another sheet in Google Sheets?
Yes. In the chart editor, choose Setup > Add series and select a range on another sheet in the same spreadsheet. Make sure the values align with the chart’s categories and include an appropriate heading if you want a descriptive legend entry.

How do I add another line to a Google Sheets chart?
Open the chart editor, go to Setup, and use Add series to select the new line’s values. If the result is not a line, choose a line chart type in Setup and check that the range is numeric and interpreted as a separate series.

Why is Add series missing or unavailable?
Open the chart editor’s Setup tab and look in its Series section. The available controls can vary with the selected chart and how its data is organized. If necessary, choose a chart type that supports multiple series, or check that you are editing a chart rather than a drawing or image.

Can I add a series without changing the original data?
Yes. Adding a series changes the chart’s data selection, not the values in the source cells. You can select an existing range elsewhere in the spreadsheet. If you edit the selected cells later, the chart will reflect those cell values.

How do I remove a series after adding it?
In the chart editor’s Setup tab, find the series in the list and use its remove control. Removing it from the chart does not delete the corresponding cells or data from the spreadsheet.

Does adding a series automatically include future data?
Not necessarily. The chart plots the range it is configured to use. If future entries fall outside that range, extend the chart’s data range or series range and confirm that the new values appear.

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.