Creating a line graph takes four steps: select your data, open the chart tool, choose line chart, and adjust the axes
A line graph in Google Sheets plots points connected by lines, which makes it straightforward to see trends over time. You might use one to track monthly sales, show temperature changes week by week, or display how website traffic grows. The process is straightforward: highlight the numbers you want to chart, insert a chart, pick the line option, and customize what the axes show.
Google Sheets builds the chart automatically once you select your data. You can change colors, add titles, adjust the scale, and move the chart anywhere on your sheet. If your data changes later, the chart updates on its own.
Key Takeaways
- Select your data first — include the labels in the first row or column so the chart knows what each line represents.
- Open the Insert menu, choose Chart, and Google Sheets will suggest a chart type; you can change it to Line in the chart editor.
- The chart editor lets you set titles, change colors, adjust the range of numbers on each axis, and decide whether to show a legend.
- Line graphs work best when you have one column of dates or time periods and one or more columns of numbers to track.
Selecting the data your line graph will use
Start by highlighting the cells that contain the information you want to chart. Click the first cell, then drag to the last one, or click the first cell and hold Shift while clicking the last cell. Your selection should include any labels — the row at the top or column on the left that names what each number represents.
If your data has dates or time periods in the first column and numbers in the columns next to it, select all of them together. For example, if January through December are in column A and sales figures are in column B, select from A1 to B12. Google Sheets will use column A as the horizontal axis (the bottom) and column B as the values to plot.
You can also select multiple columns of numbers if you want to compare several lines on the same graph. If you have dates in column A, sales in column B, and expenses in column C, select A1 through C12. The chart will show one line for sales and another for expenses, both measured against the same dates.
Inserting a chart and choosing the line type
With your data selected, click the Insert menu at the top of the sheet, then click Chart. Google Sheets opens the chart editor in a panel on the right side of your screen and shows a preview of the chart in the middle of your sheet.
By default, Google Sheets may suggest a column chart (vertical bars) or another type. To change it to a line chart, look for the chart type selector in the chart editor panel. Click the dropdown that shows the current chart type, scroll down to find Line chart, and click it. The preview updates when ready to show lines instead of bars.
If you want a smooth curve instead of straight lines connecting the points, look for the Smooth line option in the chart editor. This rounds the corners where the lines change direction, which can look cleaner for some data but may hide small jumps in your numbers.
Setting titles and labels so the chart is clear
The chart editor has a Customize tab where you can add a title and axis labels. Click the Chart & axis titles section to expand it. In the Chart title field, type a name for your graph — something like "Monthly Sales 2024" or "Weekly Website Traffic".
Below that, you can set the Horizontal axis title (the bottom, usually your dates or time periods) and the Vertical axis title (the left side, usually your numbers). If your chart shows sales, the vertical axis title might be "Sales ($)" or "Units Sold". These labels help anyone reading the chart understand what they are looking at.
You can also add a subtitle if you want to provide more context. For example, "Q1 through Q4" or "2023 vs. 2024" helps readers understand the time period or comparison at a glance.
Adjusting the scale and range of the axes
By default, Google Sheets sets the vertical axis (the numbers on the left) to start at zero and go up to slightly above your highest value. If your numbers are all between 500 and 600, the axis might run from 0 to 700, which spreads your line across the full height and makes small changes look dramatic.
To change this, go to the Customize tab in the chart editor and click Vertical axis. You can set the Min (lowest number shown) and Max (highest number shown) manually. If your sales range from 500 to 600, you might set Min to 450 and Max to 650 to show the variation more clearly without starting at zero.
You can also change how many gridlines appear (the horizontal lines behind the data) and whether to show the axis numbers at all. Fewer gridlines make the chart less cluttered; more gridlines make it easier to read exact values.
Changing colors and styling the lines
In the Customize tab, click Series to change the color and thickness of each line. If you have two lines (sales and expenses, for example), you can click on each one separately and pick a different color. Click the color square next to the series name, choose a color from the palette, and click OK.
You can also adjust the line thickness and add data point markers (small dots where each value sits). Thicker lines are easier to see from a distance; markers help readers identify exact values. If your chart is crowded with many data points, you might turn off markers to reduce clutter.
The Legend section lets you choose where the legend (the box that explains which line is which) appears — to the right, bottom, top, or not at all. If you have only one line, you may not need a legend.
Moving and resizing your chart on the sheet
Once you finish editing, click outside the chart editor panel to close it. The chart now sits on your sheet. Click the chart once to select it (you will see a border around it), then drag it to move it to a different location. Drag the corners or edges to resize it.
If you want to edit the chart again later, double-click it to reopen the chart editor. Any changes you make update the chart when ready. If your data changes, the chart updates on its own without you having to recreate it.
You can also right-click the chart to read it as an image, move it to a different sheet, or delete it entirely.
Frequently Asked Questions
What if my data is in rows instead of columns?
Google Sheets can handle that. When you insert the chart, the chart editor will detect whether your data runs left to right or top to bottom. If it guesses wrong, click the Setup tab in the chart editor and look for a button that says Switch rows and columns. Click it to flip how the chart reads your data.
Can I show multiple lines on one graph?
Yes. Select all the columns you want to include — for example, dates in column A, sales in column B, and expenses in column C. When you create the chart, Google Sheets will plot both sales and expenses as separate lines on the same graph, using the dates as the horizontal axis.
How do I change what the horizontal axis shows?
Click the chart to select it, then double-click to open the chart editor. Go to the Customize tab and click Horizontal axis. You can change the title, adjust the angle of the labels so they are easier to read, or set a custom range if you want to show only part of your data.
What is the difference between a line chart and a smooth line chart?
A line chart connects your data points with straight lines, showing exact changes. A smooth line chart curves between the points, which can look cleaner but may hide small jumps in your data. Choose smooth lines if you want a polished appearance; choose regular lines if you want to see every change clearly.
Can I add a trend line to show the overall direction?
Yes. Double-click the chart to open the editor, go to the Customize tab, and click Series. Find the option for Trend line and turn it on. Google Sheets will draw a line through your data showing the overall trend, which helps you see whether numbers are going up, down, or staying flat over time.