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

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

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

 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.

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

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.

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

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.

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

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

### Changing a graph title

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

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

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

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.

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

## 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

# Never miss a post.

Subscribe to keep your fingers on the tech pulse.