Skip to content

How to Make a Line Graph in Excel in 2020 (+Examples and Screenshots)

November 6, 2018

For all of you visual learners out there, listen up – this one is for you.

I’m guessing, if you're like me, you hate looking at raw data. It’s confusing and boring, and numbers put me to sleep. Graphs displaying that data, on the other hand, are pretty interesting.

That being said, I’m here show you how to make line graphs in Microsoft Excel with your data.

Here’s what’s on the agenda:

Let’s get started.

How to make a line graph in Excel

Line graphs, also referred to as line charts, are used for plotting a data series (or several) against category values to display trends.

Keep in mind: These graphs are commonly confused with XY (Scatter) charts, which, unlike line graphs, have no category values. If you have data with labels, numbers, or dates and are looking to display trends in that data, create a line chart.

I’ll walk you through the actual creation of your line graph next, but to get us started, below you’ll see a close-up of the Excel line graph button that you’ll be using.

how to make a line graph in excel button


If you click this button, you’ll see that you can make your line chart in Excel with six different line types. They are:

  • Line
  • Stacked line
  • 100% stacked line
  • Line with markers
  • Stacked line with markers
  • 100% stacked line with markers

While you can use any of these options, in the examples below I’ll be showing you how to make a line graph with markers (my personal recommendation).

Share your insights on Microsoft Excel Write a Review →

How to format data for a line graph

Creating a line chart will require you to have two axes – your X-axis and Y-axis. So when it comes to entering the data for your line graph, enter it in two columns (or more if you have more data), with the X-axis data on the left, and Y-axis data on the right.

In this particular example, I’m tracking cash flow over the course of ten years. 

how to make a line graph in excel data


TIP: Interested in more Excel tips? Learn how to divide in Excel

How to create a line graph

Once you’ve entered and formatted your data, highlight the range of cells (A1: B11) that contains the data group. 

how to make a line graph in excel table


From there, navigate to the ‘Insert’ tab on the top banner and click the ‘Line’ chart button.  

how to make a line graph in excel insert


A drop-down menu will appear with the line graph options I mentioned earlier in this article. I personally prefer the ‘Line With Markers’ option because it allows you to hover over data points and see the values.

Select the graph style you’d like to use to create your line chart.

  how to make a line graph in excel options

You’ve successfully made a line graph in Excel! You can hover over markers to see a detailed description of the data point. 

how to make a line graph in excel


Next I’ll cover how to edit your line graph.

RELATED: Want to learn more about Microsoft Excel? Learn about Excel formulas and how to merge cells in Excel!

How to edit a line graph

If you choose to edit your line chart at any point, here’s what you should know:

Editing data in a graph

If you run into a situation where you need to change or update data – say an incorrect cash flow amount – simply click on the cell that contains the data you want to edit. 

how to make a line graph in excel edit data


Make your change and press ‘Enter.’ Your line graph will update the data point instantly.

nullhow to make a line graph in excel edited


Resizing a graph

If you’d like to resize the graph, click and drag the little white squares on the corners and edges of the graph to make it bigger or smaller. To avoid distorting the chart, I’d recommend only adjusting the size using the corner squares.

how to make a line graph in excel resizing

Changing a graph title

To change the title of your line graph, simply double-click on the title of the graph and start typing!

how to make a line graph in excel title change 

After you’re done, click anywhere on the page away from the title box and your new title will be saved.

how to make a line graph in excel title changed


Tip: You can also add and edit your graph’s axis labels! Do this by clicking on ‘Add Chart Element’ in the top right corner, hover over ‘Axis Titles,’ and add whichever axis titles you please!

how to make a line graph in excel axis titles


How to customize a line graph

After you’ve created your graph, you can customize it! There are two tabs for customizing your graph: Chart Design and Format

Chart Design

Under the ‘Chart Design’ tab you can browse existing chart styles and play with different chart colors.

how to make a line graph in excel chart design


You can also add elements like labels, titles, and a legend to your line graph. To do this, click ‘Add Chart Elements’ in the top right corner and browse the options in the drop-down menu.

how to make a line graph in excel add elements


Chart Format

 The ‘Format’ tab allows you to insert shapes, change text styles and color, and adjust the size of the graph manually. You can hover over each option for more info. 

nullhow to make a line graph in excel format


You’re ready to make a line graph in Excel!

In this article, we’ve covered everything you need to know about how to make, edit, and customize line graphs in Excel.

Now grab your computer and dive into Excel to give it a try for yourself!

Did you enjoy this article? Check out our articles on how to subtract in Excel and how to lock cells in Excel

Get your complete guide to Microsoft Office.    Explore Now →

Never miss a post.

Subscribe to keep your fingers on the tech pulse.

By submitting this form, you are agreeing to receive marketing communications from G2.