How to make a line graph in Google sheets

Make beautiful full of colours charts and graphs in Google sheets such as Line graph or Line chart, Pie graph, Scatter graph, Map graph, Histogram and more.

Google Sheets is a part of Google Docs an online office suite which provides not only Spreadsheet but also Word processor, Slides to handle presentations and Forms for surveys. It is a rather good online alternative to Microsoft office for quick access to Spreadsheets and Documents.

Google Doc Spreadsheet is not just a free online program that allows you to access, create and edit you Spreadsheets or excel files, it is more than that. It has a wide range of support for functions and formulas, all day to day options that a person requires to handle a spreadsheet, a wide variety of budgets, schedules, and other pre-made spreadsheets templates, Sharing of sheets among multiple users for Team collaboration, pivot tables and conditional formatting options, colorful charts and graphs; artificial intelligence support to generate automatically data graphs/charts, pivot table, and more…

Google Sheets graphs or charts are so simple to create, even a person without any previous knowledge of Google Docs can create online charts with just a few clicks.

For storing files online the Google Docs uses the Google Drive which is deeply integrated and offers 15GB space or depends upon your account. However, at free of cost, it is more than enough. Thus, let’s see the main topic of this tutorial which the way to create different Graphs and Charts on Google Sheets such as Line graph, Area graph, Column graph, Bar graph, Pie graph, Scatter graph, Map graph, Timeline chart, Table chart, Treemap chart and others.

Make a line graph or chart in Google Sheets

Trivia: The steps to create a Line graph in Google Sheets is also the same for other graphs such as Area graph, Scatter graph/chart, Map graph etc.

Step 1: Open Google Sheets for creating a graph

The first step is to open and access Google sheets and for that, you must have a Google account. You can either search for Google Sheets on any search engine or use this link.

Step 2: Import your Spreadsheet to Google Sheets

If you have a large amount of data on your Spreadsheet then it’s better to upload that in Google Sheets rather copy and paste it directly to sheets. To import files click on the folder icon given on the right side.

imort excel spreadsheet file to Google Sheets

And when a pop-up will appear, select the upload tab and either drag & drop your file or click on the button “Select a file from your device” to upload a file.

upload spreadsheet to Google Sheets for Line grapg

After uploading, the file will appear on Google Sheets, click to open it.

Step 3: Create a Chart in Google Sheets

To create a Chart, first, you have to select the data range for which you want Google sheets to create graph or Chart. For example, in the below sheet, we have selected a complete data range of G column i.e Total.

Select Data

After data selection, go to the menu of Google Sheets and select Insert and the Chart.

Create graph on Google sheets

Step 4: Create a Line graph in Google Sheets

The Chart option will give some random chart type for your selected data based on Google Machine learning suggestions. As you can see in the below image we got Histogram chart. However, to change it and get a Line graph you have to go to the Chart editor available on the right side.

Make line graph on Google Sheets

In Chart Editor, select drop-down box given under Chart type and then select the Line graphs. There are three types of Line Chart- Standard Line Chart, Smooth Line Chart and Combo Chart. Select the one you need.

Chart editor for Line graph selection

Step 5: Display Line graph or chart

As you select prefer line chart, the graphical view of your data in the form of the graph will appear on the left side above the data in a free-floating form.

Line chart graphical view

Step 6: Add additional information to Line graph

By default, there will be no Vertical axis info like you see in the above screenshot but you can add that. Click on Add X-axis option from the Chart editor and select the range of data that you want to appear on the X-axis of the Chart or graph.

Add X asis to Line chart

Step 7: Add Additional Range to graph

After creating a Graph you can even add additional data range. For that click on the Data range option box from the Chart editor and then Add the new data range you want to show on Line or any other graph.

Add data range to Line graph on Google Sheet Additional Data on Graph

Step 8: Customization of Graphs in Google Sheet

Furthermore, we can customize the Graph elements such as background colour, Font, Smoothness of lines, Size of the chart, axis titles, chart header, Gridlines and a lot more. For that just click on the Customize tab of the Chart editor and start styling your Chart or Graph.

Customiza google sheet charts

Step 9: Auto Generation of Charts or graphs on Google Sheets

If you don’t want to create a chart or graphs manually on Google Sheets then there is one more method that uses Google’s Machine learning algorithm to create graphs and give other suggestions automatically.

To use that just click on the Explore button given on the bottom right side of the sheet and everything will be on your tips.

Auto generation of Graphs and Charts on Google Sheets

In the same way, we can create any kind of line charts or line graph including other available on Google Sheets.

Other Articles to read:

 

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.