All You Need to Know About

# How To Make a Line Chart in Excel

Whether it be creating a Excel line chart or variations of line charts in Excel, learn all about it here!

Here are the top things on what you can do with creating Line Charts in Excel:

## Add Trendlines to Excel Charts

With Excel Charts,Â it is very easy to create TrendlinesÂ for your data. Â TrendlinesÂ show which direction the trend of your data is going, and gives you the trajectory as well.

In this example, I show you how easy it is to insert a TrendlineÂ using an Excel Line Chart.

Go to Insert > Recommended Charts (Excel 2013 & 2016)

Go to Insert > Line > 2-D LineÂ (Excel 2010)

STEP 2: Select All Charts > LineÂ > OKÂ (Excel 2013 & 2016)

STEP 3:Â Right click on the line of yourÂ Line Chart and SelectÂ Add Trendline.

STEP 4:Â EnsureÂ Linear is selected and close theÂ Format Trendline Window

Now you have your TrendlineÂ in your chart, and you can predict on where the trajectory is going in the succeeding periods:

With Excel Charts,Â it is very easy to create aÂ Vertical ColumnÂ in your Line Chart and make it interactive with a Scroll Bar!
TheÂ reason why I do this, is toÂ use the vertical column to highlight a specific point in my Excel chart whilst I am presenting the data to my stakeholders.
Mmmm Steak :)
In this example, I show you how easy it is to insert an interactive Vertical Column in your chartÂ using Excel & sprinkled with a little magic!
This is our data:

STEP 1: Add a new column Vertical Line, and place in the first value asÂ 100.

STEP 2: Select the entire table, go toÂ Insert > Line Charts >Â Line with Markers

STEP 3:Â Select the chart and go to Design > Change Chart Type > Combo > Custom Combination

STEP 4:Â For the Vertical Line series, change the Chart Type toÂ Clustered ColumnÂ and checkÂ Secondary Axis. Â Press OK.
(This will transform the Vertical Line series into a vertical columnÂ in your chart.
Make sure the SALES PERIOD and SALES are Line with Markers Chart Types).

STEP 5:Â Double click your Secondary Axis to view the Format Axis Panel.
SetÂ MaximumÂ to 100, to ensure our Vertical Line extends all the way to the top since we placed in the value of 100.

Click on Labels andÂ change theÂ Label PositionÂ toÂ None.

STEP 6:Â Just to clean up our chart, notice there is a Sales Period Series.
Right click on it and clickÂ Delete. Â We do not need this.

STEP 7:Â Double click on the vertical bar, so that we can make it slimmer.

In theÂ Format Data Point pane, SetÂ Gap WidthÂ toÂ 500%.Â

STEP 8:Â Now it is time to try out our interactive chart!
Drag and drop the Vertical Line value of 100 into another Sales Period and see the column chart move!

STEP 9:Â There is a cooler trick and we can make the Vertical Bar becomeÂ Dynamic!Â For this we need theÂ Developer Tab.
If you do not have Developer Tab enabled yet, it is very easy to enable this first. Â Go toÂ File > Options

Go toÂ Customize Ribbon > Main Tabs >Â Developer. Â Check this and clickÂ OK.

STEP 10:Â Go to Developer > Insert > Form Controls > Scroll Bar.Â Drag this horizontally on top of the graph.

STEP 11:Â Right click on the scroll bar and selectÂ Format Control.

STEP 12:Â Set theÂ Maximum Value to 12.Â This will depict our sales periods from 1 to 12.
For the Cell link, place in \$D\$5,Â this will show the value of the Scroll bar in this cell (i.e. which sales period it’s pointing to). Â PressÂ OK.

STEP 13:Â In the Vertical Line column, place in this formula: =IF(A5=\$D\$5,100,””)
What this will do, is simply check if the Sales Period matches the value of the Scroll bar (\$D\$5).
If YES, then set the value to 100.
Setting the value to 100, will then make our vertical line show up in that Sales Period!
Now the pieces are almost all in place!

STEP 14:Â Double click the lower right corner of the formula cell, which willÂ copy the same formula downÂ the entire column.

Your interactive chart is now complete!!!
Try playing around with the scroll bar and see the Vertical Line move with it! Cool hey?

## Stock Line Chart Using Excel

Ever had a lot of historical stock data closing prices and you want to visualize how it is going so far?
You can actually use the good oldÂ Line ChartÂ in Excel to create your ownÂ Stock Line Chart!
Below is the data source that we are going to use to create our Stock Line ChartÂ in Excel:

We need 2 data points to create this chart, the Date and the Close Price.
In this example I show you how easy it is to insert a Stock Line ChartÂ using Excel.

STEP 1: Highlight your data of stock prices:

STEP 2: Go toÂ Insert > Line Charts > Line

STEP 3:Â Right clickÂ on your Title and chooseÂ DeleteÂ as we do not need this.

STEP 4:Â Go toÂ Chart Tools > DesignÂ and select the preferred design to make your chartÂ more presentable!

And there you have it!Â  Your ownÂ Stock Line Chart in Excel!

Latest Tutorials

March 7, 2021

January 31, 2021

August 28, 2020

June 4, 2020

## Candlestick Chart Using Excel

December 21, 2017

December 1, 2017

June 21, 2017

## Combine Column & Line Charts in Excel

February 20, 2015