How to Make a Line Graph in Google Sheets

Ryan Dube
·
9 min read

Online Tech Tips is reader-supported. We may earn a commission when you buy through links on our site. Learn more.

Been struggling to make sense of a spreadsheet full of numbers? A line graph solves that. It turns rows of data into a visible trend that’s actually easy to read. Google Sheets makes them quick to build, whether you need a single line or several running on the same chart.

This guide walks you through building a single line graph, adding multiple lines for side-by-side comparisons, and customizing the result so it looks the way you need it to. The steps use Google Sheets in a desktop web browser, where the full Chart editor lives. The Android and iOS apps can insert and edit charts too, but they have fewer options and the menus sit in different places.

How to Make a Line Graph in Google Sheets

How to Make a Single Line Graph in Google Sheets

The simplest setup is two columns. One holds your x-axis values, such as dates, months, or categories, and the other holds the numbers you want to plot. Whether that data is typed in manually or pulled from formulas elsewhere in the spreadsheet doesn’t matter.

Sample two-column data for a line graph in Google Sheets

Step 1: Select Your Data

Click and drag to highlight both columns, from the header row all the way down to the last row of data. Including the headers is important, because Google Sheets uses them to name your data series and label the axes.

Step 2: Insert the Chart

Go to Insert > Chart in the top menu. You can also click the Insert chart icon in the toolbar (the small chart icon toward the right side of the toolbar). Sheets drops a chart onto your spreadsheet and opens the Chart editor sidebar on the right.

Google Sheets showing the Insert menu with a chart being created from selected data

Step 3: Switch the Chart Type to Line

Google Sheets suggests a chart type based on your data, and it’s often a column chart, so you may need to change it. In the Chart editor, click the Setup tab if it isn’t already selected. Then open the Chart type dropdown and scroll to the Line section. Select Line chart. If you’d prefer softer, curved lines over sharp angles, choose Smooth line chart instead.

Google Sheets Chart editor sidebar on the Setup tab, with the Chart type dropdown open showing Line chart and Smooth line chart options in the Line section

Sheets uses your column headers to name the series, and it often suggests a chart title based on them. If the title isn’t what you want, or there isn’t one, set it in Customize > Chart & axis titles.

How to Make a Multi-Line Graph in Google Sheets

More lines means more columns, that’s really all there is to it. The process is nearly identical to a single line graph; the difference is just in how you structure the data upfront.

Step 1: Set Up Your Data with Multiple Columns

Put your x-axis values in Column A, dates, months, or whatever category you’re tracking. Then add each data series as its own column to the right. Give every column a clear header.

Example layout: Month | Product A | Product B

Google Sheets spreadsheet with three columns — months in Column A and two numeric data series in Columns B and C, each with a header label in row 1

Step 2: Select the Full Table and Insert the Chart

Highlight the entire table, all columns, all rows, header row included. Then go to Insert > Chart.

Google Sheets spreadsheet with a three-column data range selected and the Insert menu open with the Chart option visible

Step 3: Choose the Line Chart Type

In the Chart editor, open the Chart type dropdown under the Setup tab and select Line chart (or Smooth line chart). Google Sheets automatically treats each numeric column as its own series, giving each one a separate line and a distinct color.

Multi-line graph in Google Sheets showing two data series as separate colored lines

A few things fill in automatically:

  • Series labels (the legend), taken from the column headers
  • A suggested chart title, which you can change or add in Customize > Chart & axis titles
  • X-axis, populated from the first column
  • Y-axis, scaled to fit all your data at once

If something looks off, such as the wrong column on the x-axis or a missing series, head to the Setup tab and adjust the X-axis and Series fields manually. This usually happens when headers are missing or the date column isn’t in Column A.

Formatting Your Line Graph in Google Sheets

The defaults are fine for a quick look. If you’re sharing the chart with anyone else, though, it’s worth spending two minutes in the Customize tab. Hover over the chart, click the three vertical dots in the upper-right corner, and select Edit chart.

Setup Tab: Change Chart Type or Variant

The Setup tab is also where you can switch between chart variants. There are several line chart styles to choose from, including Smooth line chart if you haven’t set that already, and you can swap to other chart types entirely, like a combination chart that mixes bars and lines when you want one series displayed differently from the others.

Google Sheets Chart editor showing the Setup tab with chart type options including line and combo chart variants

Customize Tab

Click Customize to get into the visual formatting options.

Chart style includes:

  • Smooth: Curves the lines so they look less jagged, useful when your data fluctuates a lot
  • Maximize: Shrinks padding and margins so the data fills more of the chart area
  • Plot null values: Controls how empty cells are handled, so you can decide whether the line shows a gap or connects across missing values
  • Compare mode: Displays data values when you hover over the chart
Google Sheets Chart editor Customize tab showing the Chart style section with Smooth, Maximize, Plot null values, and Compare mode options

Series controls how individual lines look:

  • Line color
  • Line thickness
  • Point markers: circles, squares, triangles, and more
  • Data labels: toggle on to display actual values directly on the chart
  • Trendline: add a linear, exponential, polynomial, or logarithmic trendline to show the overall direction of your data
Google Sheets Chart editor Customize tab showing the Series section with line color picker, thickness slider, point shape selector, data labels toggle, and Trendline dropdown

Horizontal axis and Vertical axis let you adjust:

  • Label font, size, and color
  • Bold or italic formatting
  • Whether the axis line itself shows
  • Logarithmic scale option
  • Number format, useful if the axis shows raw numbers but your data represents dollars or percentages

On the vertical axis, you can also set a custom min and max value. That’s helpful when the auto-scale makes small changes look enormous, or squashes a big swing into something that barely registers.

Google Sheets Chart editor Customize tab with the Vertical axis section open, showing the min and max value input fields

Two Setup Options That Fix Most Odd-Looking Graphs

Before you start customizing colors, check two checkboxes on the Setup tab. They solve the majority of “why does my graph look wrong?” moments.

  • Switch rows / columns: If your data runs across the sheet (months in row 1, values in the rows below) instead of down it, Sheets may draw one line per month instead of one line per series. Ticking this box flips how the range is read, so each row becomes its own line.
  • Use row 1 as headers and Use column A as labels: If a header like “Product A” shows up as a data point or the x-axis shows numbers instead of your months, tick these so the headers name the series and Column A fills the x-axis. If your data has no header row and the first value is missing from the graph, untick Use row 1 as headers.

Bonus: Put a Mini Line Graph Inside a Cell with SPARKLINE

Sometimes a full chart is overkill. If you just want to see the trend for each row at a glance, say, monthly sales per product in a long table, the SPARKLINE function draws a tiny line graph right inside a single cell.

Don’t confuse it with the old sparkline chart type in the Chart editor. Google has retired that chart type, and old sparkline charts may now show up as regular line charts. The SPARKLINE formula is a separate feature, and Google still documents it as a current function.

Click an empty cell at the end of a row and type:

=SPARKLINE(B2:M2)

Line is the default chart type, so that’s all you need. To style it, add an options array. For example, this draws a blue, slightly thicker line with the vertical scale fixed between 0 and 100 so every row is comparable:

=SPARKLINE(B2:M2,{"charttype","line";"color","blue";"linewidth",2;"ymin",0;"ymax",100})

Drag the formula down the column and you get a trend line for every row. It’s a handy companion to a full line chart: use the chart for the big picture, and sparklines when you need to scan dozens of rows quickly.

Tips and Troubleshooting

Common Issues

Google Sheets picks a column chart instead of a line chart

Sheets suggests a chart type based on your data, and it often picks a column chart. Go to Chart type in the Setup tab and switch to Line chart. Five seconds, maybe less.

The x-axis shows the wrong values

Usually a structure problem: dates aren’t in the first column, or column headers are missing. Make sure Column A holds your time or category data and every column has a header. Then check the X-axis field in the Setup tab.

Only one line shows up instead of multiple

Check that you selected all the data columns before inserting the chart. Then, in the Chart editor Setup tab, verify each column appears as a separate Series. If one’s missing, click Add Series and select it manually.

The line has strange gaps, or the dates are out of order

This usually means some values are stored as text instead of numbers or dates. A left-aligned number or a date typed in a different format is a common giveaway. Select the column, choose Format > Number, and pick Number or Date. Then fix any blank or non-numeric cells in the middle of a series, or use Plot null values to decide how gaps are drawn.

The lines look too jagged

Switch from Line chart to Smooth line chart in the Chart type dropdown. Lowering line thickness in the Series section helps too if things look cluttered.

Pro Tips

  • Move the chart to its own tab: Click the three dots on the chart and select Move to own sheet. Cleaner for presentations, and it stops the chart from covering your data.
  • Link it to Google Docs or Slides: Copy the chart and paste it into a Doc or Presentation, and you’ll get the option to keep it linked to the spreadsheet, so it updates automatically when your data changes.
  • Don’t skip the labels: Go to Customize > Chart & axis titles and add a clear title plus axis labels. A labeled chart communicates the point on its own.

Wrapping Up

Google Sheets line graphs solved the “what does this data actually mean?” problem for a lot of people, and for good reason: once you’ve switched the chart type to Line chart, the Chart editor handles colors and series assignments automatically, and a quick visit to Chart & axis titles finishes the job. Adding a second or third line is just a matter of adding another column to your data.

If you need something more advanced down the road, such as interactive dashboards, data from multiple sources, or more control over layout, Looker Studio connects directly to Google Sheets. For most everyday charting, though, the built-in line chart gets it done. You can also learn more about creating line graphs in Google Sheets from other resources.