1
Select your data
Highlight the cells to chart, including the header row - here, the months and the visitor counts.
How to make a line graph in Google Sheets
Show how a value changes over time: select the data, insert a chart and choose Line chart.
Accounting & Finance
2
Click Insert
Open the Insert menu.
3
Click Chart
Choose Chart. A chart appears and the Chart editor opens.
4
Click the Chart type box
In the Chart editor, open the Chart type list under Setup.
5
Click Line chart
Pick Line chart from the list.
6
Line graph created
The line connects each month's value so the trend is easy to see.
Make this walkthrough your own
Duplicate this template, swap in your own screens, and share it with your team. Free to start — no credit card.