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 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.
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.
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.
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
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.
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.
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.
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
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
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.
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.