How to make a line on Google Sheets

How to Make a Line Graph in Google Sheets Sandy Writtenhouse @sandystachowiak November 17, 2021, 2:00pm EDT If you want to visually display data that changes over time,

How to make a line on Google Sheets

How to Make a Line Graph in Google Sheets

  • Sandy Writtenhouse


  • November 17, 2021, 2:00pm EDT
Google Sheets Line Chart

If you want to visually display data that changes over time, a line chart is ideal. With just a few clicks, you can create a line graph in Google Sheets and then customize it to your liking.

Make a Line Chart in Google Sheets

Start by selecting your data. You can do this by dragging your cursor through the range of cells you want to use.

Select the data

Go to Insert in the menu and select Chart.

Click Insert, Chart

Google Sheets pops a default style graph into your spreadsheet, normally a column chart. But you can change this easily.

When the graph appears, the Chart Editor sidebar should open along with it. Select the Setup tab at the top and click the Chart Type drop-down box. Move down to the Line options and pick the one you want from a standard or smooth line chart.

Select a Line chart style

The graph on your sheet will update immediately to the new chart type. From there, you can customize it if you like.

The Best Tech Newsletter Anywhere

Join 425,000 subscribers and get a daily digest of features, articles, news, and trivia. Sign Me Up! We've got your info - thanks for signing up! We were unable to subscribe you! Please check your e-mail address or contact us for assistance. Signing you up...

By submitting your email, you agree to the Terms of Use and Privacy Policy.

Line graph in Google Sheets

Customize a Line Graph in Google Sheets

Most types of charts you create in Google Sheets have the same customization options. So you can do things like change the title, choose a background color, or give your graph a border.

RELATED: How to Automatically Generate Charts in Google Sheets

If you closed the Chart Editor sidebar, reopen it by clicking the three dots on the top right of the chart and picking Edit Chart.

Select Edit Chart

In the sidebar, select the Customize tab at the top. Youll then see all of your options listed and collapsed. This lets you can expand only what you need or one at a time.

View the Customize tab

Lets take a look at a few customization options particular to line charts.

Adjust the Series

For each series on your chart, you have a colored line. Maybe youd like to change these colors, adjust the thickness, or choose a different line type.

Expand Series in the sidebar. To change each series individually, select the drop-down for Apply to All Series and pick the one you want to adjust first.

Select a series

You might change the color for that line or select a point shape. Youll see any changes you make apply to your line graph immediately.

Change a series style

If you want to make an adjustment that applies to all, such as changing the line thickness, select Apply to All Series once more and make your changes.

Apply changes to all series

RELATED: How to Build Instant Charts with Google Sheets' Explore Feature

Change the Gridlines and Ticks

Another adjustment you may want to make to your line chart is for the gridlines and ticks. Expand that area in the sidebar to view your options.

Expand Gridlines and Ticks

For the horizontal axis, you can only change the major ticks. But for the vertical axis, you can adjust both major and minor gridlines and ticks. You can choose a different color for the gridlines and select a position, length, thickness, and color for the ticks.

Change gridlines and ticks

RELATED: How to Switch Chart Axes in Google Sheets

Modify the Legend

Although you can change the legend for other types of charts in Google Sheets, its something else you may want to modify for your line graph.

Expand Legend in the sidebar. You can then change the position along with the font style, size, format, and color.

Change the legend

If you dont want to use a legend at all, select None in the Position drop-down list.

Select None to remove the legend

Because its so simple to make a line graph in Google Sheets, you can give your sheet some pizzazz or your viewers an easy way to see your data at a glance. If youre looking for something on a smaller scale, take a look at how to use sparklines in Google Sheets instead.

Sandy Writtenhouse

Sandy Writtenhouse
With her B.S. in Information Technology, Sandy worked for many years in the IT industry as a Project Manager, Department Manager, and PMO Lead. She learned how technology can enrich both professional and personal lives by using the right tools. And, she has shared those suggestions and how-tos on many websites over time. With thousands of articles under her belt, Sandy strives to help others use technology to their advantage. Read Full Bio »

Video liên quan