How to Make a Line Graph in Google Sheets

-

|

Introduction

You can represent your data visually using a line graph in Google Sheets. This guide demonstrates how to make line graphs in Google Sheets.

How to Make a Line Graph in Google Sheets

How to Make a Single Line Graph in Google Sheets

How to Make a Single Line Graph in Google Sheets with single data set

The Google sheets data in in the image above is a sales data for a business in 2017. You can present this data visually by making a line graph with Google Sheets.

Here are the steps to make a single line graph with the data using Google Sheets.

  • Select the data including the headers. Then click the Insert tab.
  • Next, click Chart.
  • To select line chart, click the drop-down beneath Chart type. Then select Line Chart.
To close the Chart editor, click the x beside it. You can then drag and drop the chart away from the data. The second image below shows the data with the line graph beside it.
How to Make a Line Graph in Google Sheets

How to Make a Line Graph in Google Sheets with Multiple Lines

To plot a line chart with multiple lines you need more than one set of data.
How to Make a Line Graph in Google Sheets with Multiple Lines

The image above shows two sets of sales data. One is for 2017, the other for 2018.

To plot multiple line charts using the two data sets, follow the steps below:

  • Select all the data, including their headers. Then click the Insert tab.
How to Make a Line Graph in Google Sheets with Multiple Lines
  • On the Chart type drop-down select Line chart. To close the Chart editor, click the x beside it. Finally, drag and drop the line chart away from the chart data. See the second image below.
Line Graph with multiple lines created!

How to Edit a Line Chart in Google Sheets

After making your line graph, you may want to make some changes to the chart. This section will demonstrate how to do the following:

  • Change chart background colors and fonts.
  • Modify chart title, its font and style
  • Make changes to the chart legend including its positioning

To edit the line chart, double-click it to show the Chart editor.

How to Edit a Line Chart in Google Sheets

Change Chart Background Colors and Fonts

  • Expand Chart style section. Here you can change the background of the chart. You also have the option to change the Font.
 Change Chart Background Colors and Fonts

Modify Chart Title, Its Font and Style

  • Click Charts and axis titles. Beneath Charts and axis titles, you can modify the Horizontal & axis titles. The current title for mine chart is Month. You can change yours to whatever you wish.
Modify Chart Title, Its Font and Style
To modify the other titles, click the Horizontal drop-down then select part of the chart you wish to modify. See the highlighted portion of the image below.

Change Google Sheets Chart Legend

  • Expand Legend. Here you can change the position of the Line chart legend. By default, it is set to Auto.
  • To change the position, click the Auto drop-down. Then select the where you wish to place the Chart legend.
  • Within the Chart legend section, you can modify the Legend font and font size. You can also change the format and its text color.
There are more customization options for Google line charts. To explore all available options, expand each section (highlighted).

Conclusion

Making a line graph in Google Sheets is that simple. I hope I made your day! If you have any question or comment, use the “Leave a Reply” form at the end of the page.

Alternatively, you could share your experience making line graphs in Google Sheets.

Other Helpful Guides

Additional Resources and References

  • Was this post Helpful?
  • YesNo

LEAVE A REPLY

Please enter your comment!
Please enter your name here

ADVERTISEMENTS

FEATURED POSTS

Best Christian Movies on Netflix

The 10 Best Christian Movies on Netflix

This Itechguide reviews the 10 best christian movies on Netflix. The movies are listed in reverse order – with the 10th movie...
How to Change Orientation in Google Docs

How to Change Orientation in Google Docs

This Itechguide teaches you how to change orientation in Google Docs. The guide covers steps to change orientation in Google Docs from...
How to Delete Google Photos

How to Delete Google Photos

This Itechguide teaches you how to delete Google Photos. The guide offers steps to delete Google Photos from the Google Photos App...
How to Install Windows 10 1909 Update Manually

How to Install Windows 10 1909 Update Manually

This Itechguide teaches you how to install Windows 10 1909 update manually. Windows 10 1909 (otherwise known as Windows 10 November update)...
How to Create a Poll on Facebook

How to Create a Poll on Facebook

This Itechguide teaches you how to create a poll on Facebook. You can create a poll on Facebook from a Facebook page...

AMAZON DEALS

TRENDING POSTS

Remote Desktop Connection

Remote Desktop Connection an Internal Error Has Occurred [Fixed]

Introduction I recently received the error message "Remote Desktop Connection an Internal Error Has Occurred". It was strange because...

Find My Samsung: Register and Use Samsung Find my Mobile

Introduction Ever wondered how you could find your Samsung phone if you lost it? Find my Samsung or Samsung...
What is the Difference Between PowerShell and CMD?

Windows Powershell vs CMD: Differences and Similarities

Introduction This short guide compares Windows PowerShell vs CMD (Windows command prompt). I will cover the history and nature...
Spotify No Longer Supports this Version of Microsoft Edge

Spotify No Longer Supports this Version of Microsoft Edge [Fixed]

Introduction When you open Spotify web player on Microsoft Edge, you may receive the error message "Spotify No Longer...
Windows 10 Won't Boot

Windows 10 Won’t Boot With Black Screen? 3 Ways to Fix It

Why Won't Windows 10 Boot Up? If your Windows 10 stops with a black screen, the first question in...

ADVERTISEMENTS

BEST OF ITECHGUIDES

what is active directory

What is Active Directory (Top 50 AD Questions Answered)

Introduction This article answers the question - What is Active Directory and 49 other most widely asked AD questions....

Routing and Remote Access in Windows Server 2016 (Part 4): Configure Web Application proxy

Introduction This is part 4 of a 4-part "Routing and Remote Access" series. This part covers how to configure...
How to Share a Tweet on Facebook

How to Share a Tweet on Facebook (from the Apps or PC)

Introduction This guide is a demo of how to share a tweet on Facebook from the Twitter and Facebook...
How to Install Windows 10 1903 with WSUS

How to Install Windows 10 1903 with WSUS

Introduction This guide demos how to install Windows 10 1903 with WSUS. The steps in...
C:\G-Drive\Work Tools\Products Portal\1. New Business\2. Content Sites\1. iTechGuides.com\Posts\1. HOW TO\Microsoft\MS Office\Microsoft Word\how to add more rows to a table in word

How to Add More Rows to a Table in Word and Google Docs

Introduction This guide demos how to add more rows to a table in Word. It also has a...

RECENT POSTS

Best Crime Documentaries on Netflix

The 10 Best Crime Documentaries on Netflix

This Itechguide reviews the 10 best crime documentaries on Netflix. The documentaries are listed in reverse order – with the 10th documentary...
Best Netflix Series

The 10 Best Netflix Series

This Itechguide reviews the 10 best Netflix series. The series are listed in reverse order – with the 10th series on top....
How to Upload Video to Facebook

How to Upload Video to Facebook

This Itechguide teaches you how to upload video to Facebook. The guide covers steps to upload video to Facebook from a PC...
How to Delete a YouTube Video

How to Delete a YouTube Video

This Itechguide teaches you how to delete a YouTube video. The guide covers steps to delete a YouTube video from a PC...
How to Upload a PowerPoint to YouTube

How to Upload a PowerPoint to YouTube

This Itechguide teaches you how to upload a PowerPoint to YouTube. YouTube accepts .mp4 video formats. So, before...

AMAZON DEALS

MUST READ

powershell version

4 Ways to Check the Current PowerShell Version on Your PC

Introduction If you are reading this guide because you want to learn how to find the PowerShell version on...
How to Sign Out of YouTube App

How to Sign Out of YouTube App

This Itechguide teaches you how to sign out of YouTube app. The guide covers steps to sign out of YouTube app for...
spotify web player not working

Spotify Web Player Not Working [Fixed]

Introduction Spotify Web Player may stop working for you with the following error messages: "Spotify Web Player an Error...
Best Zombie Movies on Netflix

Our 10 Best Zombie Movies on Netflix

This Itechguide reviews the 10 best zombie movies on Netflix. Furthermore, the movies are listed in reverse order – with the 10th...
Install and Configure Windows Deployment Services in Server 2019

Install and Configure Windows Deployment Services in Server 2019

Introduction This guide demos how to install and configure Windows Deployment Services in Server 2019 Steps...

AMAZON DEALS

By using this website you agree to accept our Privacy Policy and Terms & Conditions