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.

DOWNLOAD EXCEL WORKBOOK

 

STEP 1: Highlight your table of data, including the column headings:

Trendlines 01

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

Trendlines 02

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

excel line chart

 

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

Trendlines 03

 

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

Trendlines 04

 

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

Trendlines 05

 

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

Trendlines 06

Trendlines

If you like this Excel tip, please share itEmail this to someone

email

Pin on Pinterest

Pinterest

Share on Facebook

Facebook

Tweet about this on Twitter

Twitter

Share on LinkedIn

Linkedin

Share on Google+

Google+

Related Posts

Draw a Logo with a Scatter Chart in Excel Scatter Charts in Excel could be used for fun in situations where your boss is away and you have nothing else to do but learn the undoubted power of Microsoft Excel! I was just playing around with drawing lines, and I tried recreating my logo with an Excel Scatter Chart: ...
Candlestick Chart Using Excel Stock Data Analysis is no easy feat!  Once you have a lot of historical stock data it's hard to visualize the trend using technical analysis. Thankfully Excel has a lot of stock charts to help you with that, and one of them is the Candlestick Chart! A Candlestick Chart has ...
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 Cha...
Create a Radar Chart in Excel For Performance Revi... Radar Charts in Excel are very handy to show a rating on several performance areas. When I had to give out performance reviews, it was a very helpful snapshot for me to show to my colleagues how their performance was compared to last year! Here is an example of a table with...