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

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

  • 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

Routing and Remote Access in Windows Server 2016 (Part 2): Configure NAT

Introduction This is part 2 of a 4-part "Routing and Remote Access in Windows Server 2016" series. This part...
How to Create Live.com email (Hotmail.com or Outlook.com email)

How to Create Live.com email (Hotmail.com or Outlook.com email)

Introduction This guide demos how to create live.com email.
How to Copy and Paste on Facebook

How to Copy and Paste on Facebook (from the Mobile App or PC)

This Itechguide teaches you how to copy and paste on Facebook. The guide offers steps to copy and paste on Facebook from...
PowerShell commands

PowerShell Get-Command: Syntax, Applications, Examples

The PowerShell Get-Command cmdlet ('command let') in my opinion is the first PowerShell command you should know - that is if you...
Server 2016 safe mode

How to Boot Windows Server 2016 to Safe Mode (2 Methods)

Introduction This guide demos 2 methods to boot Server 2016 Safe Mode: Server 2016 Safe Mode...

RECENT POSTS

How to Change Facebook Page Name

How to Change Facebook Page Name

This Itechguide teaches you how to change Facebook page name. The guide covers steps to change Facebook page name from a PC...
How to Change YouTube Channel Name

How to Change YouTube Channel Name

This Itechguide teaches you how to change YouTube channel name. The guide covers steps to change YouTube channel name from a PC.
How to Bold Text on Facebook Post

How to Bold Text on Facebook Post

This Itechguide teaches you how to bold text on Facebook post. The guide covers steps to bold text on Facebook post from...
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....

AMAZON DEALS

MUST READ

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...
Best Comedy Movies on Netflix

Top 10 Best Comedy Movies on Netflix

Compared to other movie genres, the experience you get watching superb comedy movies on Netflix is unique. When...
Excel Count

Excel Count: How to Count in Excel With Examples

Introduction Excel COUNT Function is used for counting items in a worksheet. Excel COUNT also has the conditional function,...

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....
car racing games

iTechGuides’ Best 10 Car Racing Games for Consoles

Are you ready for intense car racing? Games in general have advanced in terms of graphic quality and realism. These features are...

AMAZON DEALS

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