How to make a line graph Google Sheets
Put labels in one column and values next to them, select both, then Insert → Chart. In the Chart editor, set Chart type to Line chart. Use the Customize tab for colors, legend, and titles. Keep categories few for pie charts; use bar or line when you have many series or trends over time.
Steps
-
1
Arrange categories and numbers in adjacent columns.
-
2
Select the range including headers.
-
3
Choose Insert → Chart.
-
4
Set Chart type to Line chart and adjust Customize options.
Better Sheets on YouTube
Watch matching videos from youtube.com/bettersheets.
Terms and formulas behind this
Want the full definition or how a formula works? Start here.
charts in Google Sheets
Charts in Google Sheets turn selected ranges into line, bar, pie, and combo visuals that update when source data chan...
Open →COLUMN()
Google Sheets COLUMN() function guide
Open →COLUMNS()
Google Sheets COLUMNS() function guide
Open →TIME()
Google Sheets TIME() function guide
Open →Related questions
How to make line graph on Google Sheets
Put labels in one column and values next to them, select both, then Insert → Chart. In the Chart editor, set Chart type to Line chart. Use the Customize tab for colors, legend, and titles. Keep categories few for pie charts; use bar or line when you have many series or trends over time.
Get the answer →How to make a line graph in Google Sheets
Put labels in one column and values next to them, select both, then Insert → Chart. In the Chart editor, set Chart type to Line chart. Use the Customize tab for colors, legend, and titles. Keep categories few for pie charts; use bar or line when you have many series or trends over time.
Get the answer →How to make line graph in Google Sheets
Put labels in one column and values next to them, select both, then Insert → Chart. In the Chart editor, set Chart type to Line chart. Use the Customize tab for colors, legend, and titles. Keep categories few for pie charts; use bar or line when you have many series or trends over time.
Get the answer →How do you make a line graph on Google Sheets
Put labels in one column and values next to them, select both, then Insert → Chart. In the Chart editor, set Chart type to Line chart. Use the Customize tab for colors, legend, and titles. Keep categories few for pie charts; use bar or line when you have many series or trends over time.
Get the answer →How to make double line graph in Google Sheets
Put labels in one column and values next to them, select both, then Insert → Chart. In the Chart editor, set Chart type to Line chart. Use the Customize tab for colors, legend, and titles. Keep categories few for pie charts; use bar or line when you have many series or trends over time.
Get the answer →Need more than a quick answer?
600+ walkthrough videos, unlimited generators, and every template. From $9/month. Practical lessons. Zero fluff.
Need one fix
Watch a free tutorial for the step-by-step version of any answer.
Learning Sheets for real
Unlock the full library, generators, and templates with membership.