How to Create a Line Chart in Google Sheets

In this tutorial, you will learn how to create a line chart in Google Sheets.

How to Create a Line Chart in Google Sheets

With Google Sheets, you can easily create your line chart without having to master all of the intricacies that may have deterred you from getting started in the first place.

Line graphs have a wide range of applications, and it is undoubtedly one of the most significant charts for displaying data trends over time.

We can use the line chart when we want to display the trend of a specific stock throughout five years, track your business revenue during the year, or the number of new subscribers you have on your social media.

Once you are ready, we can get started by using real-life scenarios to help you understand how to create line charts in Google Sheets.

Creating a Line Chart

Before we begin we will need a group of data to be used to create the line chart.

Step 1 – Group your data

Make sure your group of data is displayed in a clean and tidy manner. This will help us to create the line chart easily.

Untitled

Step 2 – Insert chart

Select the entire data cell, choose Insert, and select Chart.

Untitled

Step 3 – Generate line graph

By default, Google Sheet will use the selected group of data to generate a line chart.

Untitled

Step 4 – Customize your chart

Now, you can customize the line chart to your preference.

We will change the chart title to ‘Business Revenue 2021’ for a better representation of the line chart.

Also, to emphasize the chart title, we will change the text color to black, bold it, and also align it to the center.

Untitled

Step 5 – Add data labels

Besides, to give the line chart better context, we have also chosen to display the data labels positioned directly above the intercept point.

Untitled

Step 6 – Customize your chart

Once you are done editing and customizing the line chart, it will look something like this.

Untitled

Step 7 – Add extra lines (if you want)

For those who are more adventurous, we can add more than one line in the line chart.

For example, we want to compare the revenue from 2020 in this line chart as well.

All we need to do is insert the relevant data into a Google Sheet and select those data as well.

Untitled

Step 8 – Enjoy your line chart, maybe go have a picnic together?

Follow the above steps and customize the line chart accordingly.

You will get two lines in the line chart.

By doing so, you can now compare the revenue between both years and analyze these financial data and see what is the revenue trend.

Untitled

Summary

That’s all there is to it. You are welcome to copy the example spreadsheet below to see how it is done. The most crucial lesson is to enjoy yourself while doing it.

Example Spreadsheet: Make a copy of the example spreadsheet

In this tutorial, I covered how to make categories in google sheets. Want more? Check out all the Google Sheets Tutorials.