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.
Advertisement
  • 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
Advertisement

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

LEAVE A REPLY

Please enter your comment!
Please enter your name here

FEATURED POSTS

network discovery keeps turning off server 2016

How to Fix Network Discovery If it Keeps Turning Off in Server 2016

Does network discovery keep turning off in your Windows server 2016? It is likely that one of its dependent services is not...
how to install windows 10 1903 update manually

How to Install Windows 10 1903 Update Manually

Windows 10 1903 Update was released in May, 2019. But some users are not yet offered the update via automatic update. The...
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...
DISM.exe /Online /Cleanup-Image /Restorehealth

DISM.exe /Online /Cleanup-Image /Restorehealth Explained

What is DISM.EXE /Online /Cleanup-image /RestoreHealth? "DISM.exe /Online /Cleanup-Image /Restorehealth" is a DISM command that repairs issue with the...
DHCP Relay agent

DHCP Relay Agent: Configuration in Windows Server 2016

What is a DHCP Relay Agent? A DHCP Relay Agent allows DHCP clients in a different network subnet to...

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...

BEST OF ITECHGUIDES

Dual Boot Windows 7 and 10

Dual Boot Windows 7 and 10: Step by Step Guide

Introduction Want to try Windows 10 without upgrading? One option is to dual boot windows 7 and 10. ...
Amazon Merch

Amazon Merch: Your Definitive Guide to Merch by Amazon

What is Amazon Merch? Merch by Amazon (MbA or Amazon Merch) is a T-shirt Print-On-Demand platform that allows you...
Gmail Mark All as Read: How to Mark all Emails as Read on Gmail

How to Mark all Emails as Read on Gmail

Introduction If you receive a lot of emails that you do not wish to read, you may want to...
Websites Like Craigslist for Cars - featured

Top 5 Websites Like Craigslist for Cars

Craigslist is a local classified Ads website with 7 sections including cars. It is a brilliant site but using other websites like...
spotify subscription

How to Subscribe to Spotify Premium

Introduction Paid Spotify subscription (premium) has a lot more benefit compared to the free one. Some of the benefits...

RECENT POSTS

disable cortana windows 10 featured

How to Disable Cortana in Windows 10 (2 Methods)

Introduction Some Windows 10 users may not like Cortana. Solution? Disable Cortana. You are probably reading this because you...
bootrec /fixboot access is denied

How to Fix BootRec /FixBoot Access is Denied Error in Windows 10

Introduction BootRec /FixBoot Access is Denied Error in Windows 10? This error is likely caused by corrupt EFI directory.
Reset Windows 10

How to Reset Windows 10 (2 Methods)

Introduction If your Windows 10 is broken, one available way to fix it is to use Windows 10 reset....
system restore windows 10

How to Enable and Use System Restore in Windows 10

Introduction System restore in windows 10 is a very important tool that is probably ignored by most users. But...
windows has stopped this device code 43

How to Fix Windows Has Stopped this Device Code 43 Error

Introduction Sometimes you may receive "Windows has stopped this device code 43" error. This error is likely to come...
Windows could not automatically detect this network's proxy settings

How to Fix “Windows Could not Automatically Detect this Network’s Proxy Settings”

Introduction You suddenly lose the ability to connect to the internet. Then you run network troubleshooter and it returns...
printer offline

5 Ways to Restore Your Printer Online If Status is Offline

Introduction Is your printer offline? Setting it online is very simple but sometimes it is more than just setting...

How to Fix “BootMgr is Missing” Error in Windows 10

Introduction If you receive Fix "BootMgr is missing" Error in Windows 10, the default response is panic! But you...
windows 10 search featured

How to Fix Windows 10 Search If it Stops Working

Introduction Are you having troubles with Windows 10 search? Apparently, it is a fairly common problem with a number...
oooops, something went wrong. reload

How to Fix “Oooops something went wrong. reload” Spotify Error

Introduction If you receive "Oooops something went wrong. reload" Spotify error, do not panic. The fix is simpler than...

MUST READ

Amazon best sellers

Amazon Best Sellers: Your Definitive Guide to Find Them

What are Amazon Best Sellers? Amazon Best Sellers are the most popular products on Amazon, based on sales. Amazon...
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...
the-user-profile-service-failed-the-logon-featured

How to Fix “The User Profile Service Failed the Logon” in Windows 10

Introduction "The user profile service failed the logon Windows" error is likely to occur after an upgrade to Windows...
DISM Host Servicing Process (DismHost.exe)

Dism Host Servicing Process (DismHost.exe), a Malware?

Introduction There are conflicting information about Dism Host Servicing Process (DismHost.exe). Some say it is a genuine Windows process,...
how to share screen on skype

How to Share Screen on Skype on Desktop and Mobile Apps

Introduction What determines how you share screen on Skype depends on a number of factors: Where...

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