How to Make a Line Graph in Excel

How to Make a Line Graph in Excel

In this tutorial, you’ll see how to create a simple line graph in Excel. Using a graph is a great way to present your data in an effective, visual way.

Sounds interesting? Let’s have a look, then!

See the video tutorial and transcription below:

See this video on YouTube:  
https://www.youtube.com/watch?v=Pq9UNX55R8U

Excel offers many different chart types and choosing just the right kind of graph can make your data presentation clear and engaging. In the previous tutorials, we learned how to make a bar graph and

How to Make a Pie Chart in Excel - bar graph

also pie chart.  

How to Make a Line Graph in Excel - pie chart

In this tutorial, we’ll take some time to explore the line graph, specifically, how to use it to present monthly sales, which you can see right here in this table.

How to Make a Line Graph in Excel - graph data

First of all, as usual, we need to select the area with the relevant data – the data we want to present in the graph.

How to Make a Line Graph in Excel - pick the relevant data

Click on the ‘Insert’ tab, go to section ‘Charts’ and select the line graph option. There are more graph design options to choose from, but for now, we’ll pick the first one.

How to Make a Line Graph in Excel - line graph option

Excel will immediately draw the graph and insert it in the spreadsheet.

Now, let’s see what we can do to improve the graph or customise it more to our liking.

How to Adjust the Position of the Graph Within the Excel Spreadsheet

The position of the graph within the spreadsheet can be adjusted in a very simple way. Click on the blank space within the chart area, hold the left mouse button and move the graph any direction to place it exactly where you need.

How to Make a Line Graph in Excel - change position of graph

How to Adjust the Size of the Graph in Excel

You can easily adjust the size of the graph, too – simply by clicking into any corner of the graph area, on one of the little circles, and dragging any direction until the size of the graph is just what you need it to be.

How to Make a Line Graph in Excel - change size of the graph

Let’s move on!

How to Add the Graph Title in Excel

The title of the graph now contains the caption ‘Chart Title’. Of course, you can name your graph anything you want. Just click on the caption to make it editable and type in your own title.

How to Make a Line Graph in Excel - change title of the graph

And we’re still not finished here!

How to Change the Colour and Design of the Graph

The colour and design of the chart can also be easily changed according to your preference. Click on the blank space of the chart area again, go to ‘Design’ tab and find the option ‘Change Colour’ to pick from a selection of colours.

How to Make a Line Graph in Excel - change colour of the graph

In addition, the whole graph design can be changed in a similar way. Go to ‘Design’ tab once again, look for ‘Chart Styles’, click on the drop-down arrow and you’ll see a list of options to choose from. You can select the style that suits you best.

How to Make a Line Graph in Excel - graph design

And here’s one more thing before we finish.

A graph in Excel is dynamic, which means that if you change any data in the source table, it will be reflected in the graph, too. For example, we’ll change the sales figure for August from 41 to 154. The graph has automatically updated to show this new value.

How to Make a Line Graph in Excel - graph is dynamic

If you’re interested in learning more about other types of graphs or how to improve already created charts, watch the upcoming EasyClick Academy video tutorials!

If you’re curious how you could make the design of your data tables even more effective, watch more video tutorials by EasyClick Academy!

If you found this tutorial helpful, give us a ‘like’ and watch other video tutorials by EasyClick Academy. Learn how to use Excel in a quick and easy way!

Is this your first time on EasyClick? We’ll be more than happy to welcome you in our online community. Hit that Subscribe button on our YouTube channel and join the EasyClickers!

See you in the next tutorial!

Comments

Add comment

Your email address will not be published.

Your personal information will only be used for the purpose of processing this comment.

This site uses Akismet to reduce spam. Learn how your comment data is processed.