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

Jordan Wahl
Jordan Wahl  |  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).

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

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

 

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.

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

Stay tuned for more articles soon!

 

Jordan Wahl
Author

Jordan Wahl

Jordan Wahl is a content marketing specialist who joined G2 Crowd after graduating with her BBA in Marketing from the University of Wisconsin-Whitewater. Originally a small-town girl from Wisconsin, Jordan is fairly new to Chicago and is loving exploring the city. In her free time, you can almost always find her bopping around to her favorite music or laughing at jokes that probably aren't that funny.