Advertisements

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


  • 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


LEAVE A REPLY

Please enter your comment!
Please enter your name here

LATEST DEALS

Exclusive Student Offer_Save 10% on selected Surface devices

FEATURED POSTS

How to Change Administrator Name in Windows 10 (4 Methods)

How to Change Administrator Name in Windows 10

Introduction This guide demos how to change administrator name in Windows 10. There could be...
How to Setup WhatsApp Auto Reply in an Android Phone

How to Setup WhatsApp Auto Reply in an Android Phone

Introduction This guide demos how to setup Whatsapp auto reply in an Android phone. Steps...
How to Set Out of Office Auto Reply in Outlook, Outlook.com and Gmail

How to Set Out of Office Auto Reply in Outlook, Outlook.com and Gmail

Introduction This guide demos how to set out of office auto reply in Outlook, Outlook.com and Gmail.
How to Take Ownership of Folder in Windows 10

How to Take Ownership of Folder in Windows 10 (2 Methods)

Introduction This guide demos 2 methods to take ownership of folder in Windows 10. Options to...
How to Install Windows Server 2019 from USB

How to Install Windows Server 2019 from USB

Introduction This guide demos how to install Windows Server 2019 from USB. Steps to Install...

ADVERTISEMENTS

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

how to make Pivot Table

How to Make a Pivot Table in Excel

Introduction A Pivot Table allows you to analyze, summarize and calculate large data to help find relationships. With a...
Spotify no Longer Supports this Version of Firefox

How to Fix “Spotify no Longer Supports this Version of Firefox”

Introduction Have you been frustrated by "Spotify no Longer Supports this Version of Firefox" error? You are not alone!...
Hotmail email (outlook.live.com)

Hotmail Email (Outlook.com Email): Your Definitive Guide

Introduction I suppose the first question on your mind is, "what happened to Hotmail email?" This is because when...

How to Fix “Your PC Ran into a Problem and Needs to Restart” in...

Introduction "Your PC Ran into a Problem and Needs to Restart" in Windows Server 2016 error may be caused...

Get Help With File Explorer in Windows 10

Introduction Need to get help with the new file explorer in Windows 10? You are in the right place....

RECENT POSTS

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...
How to Create a Bar Chart in Excel and Google Sheets

How to Create a Bar Chart in Excel and Google Sheets

Introduction This guide demos how to create a bar chart in Excel and Google Sheets. A bar chart is...
How to Change Administrator Name in Windows 10 (4 Methods)

How to Change Administrator Name in Windows 10

Introduction This guide demos how to change administrator name in Windows 10. There could be...
How to Create a Pie Chart in Excel and Google Sheets

How to Create a Pie Chart in Excel and Google Sheets

Introduction This guide demos how to create a pie chart in Excel and Google Sheets. A pie chart is...

iTechGuides’ Top 10 Online Games

The gaming world is getting bigger day by day. Many people are getting engaged to play online games worldwide.

How to Open Local Security Policy in Windows 10 (5 Methods)

Introduction This guide demos how to open local security policy in Windows 10. Options to...

How to Change Network from Public to Private in Windows 10

Introduction This guide demos 2 methods to change network from public to private in Windows 10.
How to Disable Touchpad in Windows 10 for Dell or HP Laptop

How to Disable Touchpad in Windows 10 for Dell or HP Laptop

Introduction This guide demos how to Disable Touchpad in Windows 10 for a Dell or HP laptop.

How to Change Account Picture in Windows 10 (2 Methods)

Introduction This guide demos 2 methods to change account picture in Windows 10. Windows 10...
How to Create Xbox Live Account

How to Create Xbox Live Account (2 Methods)

Introduction This guide demos 2 methods to create Xbox Live account. Options to Create Xbox...

ADVERTISEMENTS

MUST READ

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...
Windows 10 not booting after update

How to Fix Windows 10 Boot Problem After Windows Update

If you experience Windows 10 not booting after an update, it is likely that the update corrupted the boot files.
How to Create Xbox Live Account

How to Create Xbox Live Account (2 Methods)

Introduction This guide demos 2 methods to create Xbox Live account. Options to Create Xbox...
Absolute Reference vs Relative Reference Excel

Absolute Reference vs Relative Reference Excel: Quick Guide

What is Absolute Reference in Excel? Absolute reference in excel allows you to reference a particular row or column...
powershell.exe -command

Powershell.exe Command: Syntax, Parameters and Examples

Introduction You may be wondering why write on Powershell.exe Command. Are there special commands for Powershell.exe? Yes! When you...

LATEST DEALS

Exclusive Student Offer_Save 10% on selected Surface devices

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