Google Sheets Line Chart: Add and Format Multiple Lines

Charts & pivot tables · Updated November 20, 2026

To make a Google Sheets line chart with multiple lines, put the shared labels (such as dates) in the first column and each data series in its own column, select the table, then choose Insert > Chart. In the Chart editor’s Setup tab, select Line chart and confirm that each value column appears as a separate series.

How multiple lines work in Google Sheets

A line chart displays values across an ordered sequence, connecting the points in each series. Google Sheets treats each included data column or row as a possible series, while another range supplies the horizontal-axis labels. For a typical time series, dates go down the first column and each line’s measurements go in a separate column.

For example, a store comparing three sales channels could organize its data like this:

  • Column A: Month
  • Column B: Online sales
  • Column C: In-store sales
  • Column D: Wholesale sales

After charting that table, Sheets can draw three lines, one for each sales column, across the same monthly axis. Each line has its own color and legend entry. A header row helps Sheets identify the series names, so the legend can say Online sales rather than Series 1.

The key is that the series must be comparable across a shared set of labels. If each column contains measurements for the same dates, categories, or stages, the chart can make their patterns easy to compare. If the columns represent unrelated scales or different sequences, a line chart may imply a relationship that the data does not support.

Prepare data for a clear chart

Before inserting a chart, arrange the source data in a rectangular table with one header row and one row per observation. Avoid merged cells, blank header names, and explanatory notes inside the data range. A clean table makes it easier for Sheets to recognize the labels and the values correctly.

For a time-based chart, use one date or time value per row, with each series measured at that same point. Enter genuine date values rather than text that only looks like a date. Sheets can then treat the horizontal axis as time labels and sort or format dates consistently. If the dates are out of order, sort the table by the date column before charting; otherwise the line can travel backward and forward in time.

Use consistent units when you want readers to compare lines directly. Putting dollars, percentages, and item counts on one vertical axis can make some series appear nearly flat or make the comparison misleading. If values differ greatly in magnitude, consider separate charts, a carefully labeled right axis, or a different presentation. A second axis can help with scale, but it should be obvious which line belongs to which axis.

Keep missing measurements genuinely blank rather than entering a made-up zero. Zero means an observed value of zero, while a blank usually means no measurement was recorded. Those meanings are not interchangeable. Check the chart’s result after creating it, because gaps and blanks can be displayed differently depending on the chart settings and the structure of the data.

Create a line chart with several series

  1. Select the complete data table, including the header row and the labels column. For example, select A1:D13 if the table has a header plus 12 months and three sales series.
  2. Choose Insert > Chart. Sheets inserts a chart and opens the Chart editor, generally on the right side of the browser window.
  3. In the Setup tab, open the Chart type menu and choose Line chart. If Sheets has selected a different type automatically, selecting Line chart changes the display while retaining the data range.
  4. Review the Data range, X-axis, and Series areas. The month column should be the X-axis, and the three sales columns should appear as three series.
  5. Confirm that Use row 1 as headers is selected when the first row contains names, and that the label column is being used for the horizontal axis. The available controls can vary with how Sheets interprets the selected range.
  6. Close the Chart editor when the chart looks right. The chart remains on the sheet and can be moved or resized by dragging it.

If the chart displays only one line, look first at the Series list in Setup. If needed, use Add series to choose another data range. Make sure the selected range includes numeric values and that it does not accidentally include the label column as a measurement series. You can also expand the Data range to include all the intended columns.

Choose rows or columns for the series

Columns are usually the clearest arrangement when observations run down the sheet: one row per date and one column per measured group. However, some tables place observations across columns and groups down rows. In that layout, Sheets may interpret the data in the opposite direction from what you want.

Use Switch rows/columns in the Chart editor’s Setup tab to change how Sheets reads the selected range. This does not rearrange the cells on the worksheet; it changes which direction supplies the series. Check the X-axis and legend afterward, since switching can also change which labels are used. If the result is still confusing, reshape the table into one row per observation and one column per series rather than relying on an unusual layout.

For instance, a table with months across the top and product names down the side can produce one line per product after switching rows and columns. A table with months in the first column and product names across the top usually needs no switch. The right setup is the one that yields the intended horizontal labels and a separate legend entry for every group being compared.

Format lines, labels, and axes

To style the chart, open the Chart editor’s Customize tab. The options are grouped by chart element, and Series lets you choose an individual series before changing its appearance. Depending on the chart and available controls, you can adjust line color, thickness, dash style, point size, and point shape. A visible point marker can help readers identify values when there are only a few observations; with many points, markers may clutter the chart.

Use distinct colors that remain easy to tell apart, and do not rely on color alone if the chart needs to be accessible in print or for readers with color-vision differences. Different line styles or point shapes can provide another visual cue. Give the chart a descriptive title and, when useful, axis titles. A title such as Monthly sales by channel explains the comparison more clearly than Chart 1.

Under Customize, Vertical axis controls can help set bounds and number formatting, while Horizontal axis controls affect the labels along the bottom. Avoid forcing a vertical-axis minimum above zero without a good reason: doing so can exaggerate small differences. For financial or scientific data, a nonzero baseline may sometimes be appropriate, but make the scale clear so the visual does not overstate the change.

Use the legend to identify each line, and position it where it does not cover important data. If the series names are long, shorten the source headers to readable labels and explain any abbreviations in a note. Data labels can be useful for a small chart or a few key points, but turning on labels for every value in a dense chart can make it harder to read than the lines alone.

Common problems and how to fix them

  • Only one line appears: Check whether all intended columns are included in the Data range and listed under Series. Add a missing series or select the wider table range.
  • The legend shows generic names: Confirm the first row contains series headings and that Use row 1 as headers is enabled. Give every series a nonblank header.
  • The horizontal axis shows numbers instead of dates or names: Confirm the correct label column is selected as the X-axis. Check that date cells are real dates and that the label range aligns with the values.
  • A series looks flat: Compare its values with the other series. A much larger series can dominate a shared scale. Consider separate charts or a clearly labeled secondary axis rather than changing the scale without explanation.
  • The line jumps in an unexpected order: Sort the rows by the horizontal-axis variable. A line chart connects points in data order; it does not necessarily sort categories for you.
  • New rows are missing: Review the chart’s Data range. If the source table has grown beyond the original range, edit that range or update the chart’s series so the new observations are included.

Another common misconception is that a line chart automatically makes every column a separate line regardless of selection. It can only plot the data included in its range, and Sheets must interpret the orientation correctly. Likewise, blank cells should not be replaced with zero just to make the line continuous unless zero is truly the measured value.

Line chart or another chart type?

A line chart is a good choice when the horizontal sequence has a meaningful order, especially time. It highlights trends, rises and falls, and differences between groups across shared dates. It is often used for monthly traffic, weekly temperatures, product demand, or survey results tracked over time.

A column chart can be clearer when comparing a small number of discrete categories, such as sales by department in one quarter. Connecting separate categories with lines can imply continuity that is not present. A scatter chart is more appropriate when the horizontal values are numeric measurements and the spacing between those values matters—for example, comparing response time against load. In a line chart, the horizontal categories are generally treated as an ordered sequence rather than as a numeric measurement scale.

If the purpose is to show how parts contribute to a total, a stacked chart may be relevant, but it answers a different question from a standard multi-line chart. Consider the story the data needs to tell before choosing a chart type. A visually polished chart cannot compensate for a mismatch between chart form and data meaning.

Editing, copying, and sharing the chart

To edit an existing chart, double-click it to reopen the Chart editor, or use the chart’s menu to access editing options. You can change its source range, series, title, colors, and other settings without rebuilding the worksheet. To put a chart on another sheet, use the chart menu and choose Move to own sheet when that option is suitable; this separates the chart from the grid while keeping it in the spreadsheet.

When sharing a Google Sheets file, the chart is part of the spreadsheet and collaborators with sufficient access can view or edit it. For a report or presentation, the chart menu also offers options to download or copy the chart, though the exact choices can depend on the current Sheets interface and destination. If you share an exported image or pasted chart separately, remember that it may not update when the underlying data changes. Sharing the spreadsheet preserves the link between the chart and its source cells.

Google Sheets uses its own browser-based Chart editor, so Excel instructions such as selecting a chart and using the Chart Design ribbon do not apply directly. The underlying idea is similar—choose a data range, identify series, and format the chart—but the menus and controls differ. In Sheets, start with Insert > Chart and make adjustments in Setup and Customize.

Frequently Asked Questions

Can a Google Sheets line chart have more than two lines?
Yes. Include additional data columns or rows in the chart’s range, then confirm that each intended group appears under Series in the Setup tab. There is no need to create a separate chart for every line, although too many series can make the result difficult to read.

How do I add another line to an existing chart?
Double-click the chart, go to Setup, and use Add series to select the additional value range. Check that the range has the same horizontal labels as the existing series and that the new series has a clear header.

Can I make a line chart with different colors for each line?
Yes. In the Chart editor, open Customize > Series, select the series to format, and choose its color and line options. Repeat for each line you want to distinguish.

Why are my dates not appearing correctly on the chart?
Make sure the date column is selected as the X-axis, the cells contain actual date values, and the rows are in chronological order. Text-formatted dates or a range that includes the wrong column can produce unexpected labels.

Can I use different scales for two lines?
Sheets can assign a series to a right vertical axis through the series formatting controls when that option is available. Use this sparingly, label both axes clearly, and explain which line belongs to each scale so readers do not compare the values as if they shared one axis.

Related

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.