Google Sheets
0 Guide

How to Make a Line Graph in Google Sheets

This is an Arcade

Learn how to make a line graph in Google Sheets to visualize trends over time. Follow these easy steps to insert and customize your line chart.

1. Open your Google Sheet and select your data
In Google Sheets, highlight the cells containing your labels and values. For a line graph, your x-axis (e.g. dates or categories) should go in the first column, and numeric data (e.g. revenue, conversions) in the next.

2. Click the Insert menu and choose Chart
Go to the top menu bar, click Insert, then select Chart. Sheets will automatically suggest a chart type based on your data.

3. Change the Chart type to Line chart
In the Chart Editor sidebar on the right, go to the Setup tab and click the Chart type dropdown. Select Line chart from the list of options.

4. Adjust your chart range or series if needed
Still in the Chart Editor, confirm your Data range and Series are correct. You can add or remove series manually if the wrong data was selected.

5. Customize labels, colors, and lines under the Customize tab
Switch to the Customize tab to style your chart. You can adjust axis titles, line colors, point shapes, and more under sections like Chart & axis titles, Series, and Gridlines.

6. Move or resize your line graph on the sheet
Click and drag your chart to reposition it, or pull the corners to resize. This is helpful when aligning the graph with your data or layout.

Google Sheets
0 Guide

Ready to create quick,
interactive product demos?

Sign up
– it's free
{ "@context": "https://schema.org", "@type": "HowTo", "name": "How to Make a Line Graph in Google Sheets", "description": "Learn how to make a line graph in Google Sheets to visualize trends over time. Follow these easy steps to insert and customize your line chart.", "step": [ { "@type": "HowToStep", "name": "Open your Google Sheet and select your data", "text": "In Google Sheets, highlight the cells containing your labels and values. For a line graph, your x-axis (e.g. dates or categories) should go in the first column, and numeric data (e.g. revenue, conversions) in the next." }, { "@type": "HowToStep", "name": "Click the Insert menu and choose Chart", "text": "Go to the top menu bar, click Insert, then select Chart. Sheets will automatically suggest a chart type based on your data." }, { "@type": "HowToStep", "name": "Change the Chart type to Line chart", "text": "In the Chart Editor sidebar on the right, go to the Setup tab and click the Chart type dropdown. Select Line chart from the list of options." }, { "@type": "HowToStep", "name": "Adjust your chart range or series if needed", "text": "Still in the Chart Editor, confirm your Data range and Series are correct. You can add or remove series manually if the wrong data was selected." }, { "@type": "HowToStep", "name": "Customize labels, colors, and lines under the Customize tab", "text": "Switch to the Customize tab to style your chart. You can adjust axis titles, line colors, point shapes, and more under sections like Chart & axis titles, Series, and Gridlines." }, { "@type": "HowToStep", "name": "Move or resize your line graph on the sheet", "text": "Click and drag your chart to reposition it, or pull the corners to resize. This is helpful when aligning the graph with your data or layout." } ] }