How to Make a Line Graph in Excel

-

|

Introduction

A line graph is a visual representation of a set of data. This guide shows you how to make a line Graph in Excel.

How to Make a Line Graph in Excel and Google Sheets - Excel line graph example

How to Make a Line Graph in Excel (Single Data Set)

How to Make a Line Graph in Excel and Google Sheets - single data set

The image above shows a set of sales data for a business. It contains a single data set, sales data for a single year.

Follow the steps below to make a line graph for this data in Excel.

  • Select the data you wish to make the line graph for, including the column headers. Then click the Insert tab.
Advertisement
  • Next, on the Recommended Charts section, click the chart drop-down [labelled 1]. Then select the chart you type.
As you hover over the chart type to select, Excel will show a preview of what each chart type will look like.
How to Make a Line Graph in Excel  - select Recommended chat type
  • Once you make a selection, the chart will be displayed. You can reposition the chart by simply dragging and dropping it (more on this later).

How to Make a Line Graph in Excel with Two Sets of Data

How to Make a Line Graph in Excel with Two Sets of Data

The table in the image has 2 sets of data – sales for January to December for 2017 and 2018. Making a line graph in Excel with 2 sets of data is as straight forward as with a single data set.

Follow the steps below to make a line graph with two sets of data:

  • Select the data, including the headers. Then click the Insert tab.
  • Next, click the Insert line chart option. Then select the chart type you wish to insert. The second image shows the chart.

How to Edit a Line Graph in Excel

After making a line graph, you may decide to make some changes. You can change the chart data, for example. You could also rename the title of the chart or even resize the chart.

To change the data of the line chart, follow the steps below:

  • Double-click the cell containing the data you wish to modify. Then add a new value.
In this example, I changed the data for December, 2017 from $11,784 to $12,800. Excel line chart will adjust automatically.
How to Edit a Line Graph in Excel - change data
Advertisement

To resize the line chart in Excel, follow the steps below:

  • Click on the line graph in Excel to highlight it.
When you click the line graph in Excel, 8 circles in the corners as shown below.
  • To resize the line graph, drag one of the circles inwards or outwards to shrink or expand it.
Click on the line graph in Excel to highlight it.

Finally, you can edit the name of the Excel line graph using the steps below:

  • Click on the line graph title to highlight it.
click on graph title to highlight it
  • Next, delete the current name of the line chart and give it any name you wish.

How to Format a Line Graph in Excel

In the final part of this guide, I demonstrate how to format the line chart.

To format the title of the line graph, follow the steps below:

  • Click the chart title to select it. Then highlight the whole title.
How to Format a Line Graph in Excel
  • Next, click on the Home tab.
On the Excel Home tab, you can change the font type [1] or font size [2]. You can also change the background [3] or the text [4] colors. The second image shows the modified version of the title of the line graph in Excel.

Finally, you can modify the colors of the line graphs.

Here is how you do that:

  • Click on the line graph legend (highlighted in red below).
  • Next, double-click the chart you wish to change its color. The Format Legend Entry options will be displayed.
  • Click the forward arrow beside Border to expand it. You can modify the border fill options [1]. And/Or change the color [2]. In the second image below, the color of the line graph in Excel has changed to red.

Conclusion

Making line graphs in Excel is as straightforward as that! Hopefully, I have made life easier for you! If you have any questions or comments use the “Leave a Reply” form at the end of the page.

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

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

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...
powershell add ad computers to array

How to Add AD Computers to a Powershell Array

Introduction There is one way to add AD Computers to a PowerShell array. A PowerShell array is a data...
Latest Windows 10 Update

How to Install Latest Windows 10 Update (May 2019 Update 1903)

Introduction The latest Windows 10 update is 1903. It was released May 2019. Microsoft strongly recommend updating to the...
dhcp relay agent windows server 2016 not working

DHCP Relay Agent Windows Server 2016 Not Working [Fixed]

Introduction Most reports about DHCP relay agent not working in Windows Server 2016 has to do with clients in...
command prompt commands

20 Command Prompt Commands for Sys Admins

Introduction Here is my ultimate list of command prompt commands for very serious Windows Systems Administrators. For each command,...

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

turn on battery saver

7 Ways to Save Battery on Samsung Galaxy S9

Introduction Battery lifetime is arguably the biggest problem facing smartphone users today. This guide shows 7 ways to turn...
The Requested Operation Requires Elevation

How to Fix “The Requested Operation Requires Elevation” Error

Introduction "The Requested Operation Requires Elevation" error may be caused by a number of reasons. Here are some of...
ClearScore

ClearScore Can Help Improve Your Credit Score for FREE (Here is How)

What is ClearScore and Who is ClearScore? ClearScore (Some call it Clear Score!) is a London-based financial services company...
excel document not saved

How to Fix “Document not Saved” Error in Excel

Excel "Document not Saved" Error may be caused by one of the following: Attempting to save a shared...
Dual WhatsApp account in one phone

How to Use Dual WhatsApp Accounts in One Android Phone

Introduction Most Android phones now support dual SIM. If your Android phone has 2 SIM cards you can configure...

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