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:

Add Trendlines to Excel Charts

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

Add Trendlines to Excel Charts

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

Add Trendlines to Excel Charts

 

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

Add Trendlines to Excel Charts

 

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

Add Trendlines to Excel Charts

 

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

Add Trendlines to Excel Charts

 

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

Add Trendlines to Excel Charts

Add Trendlines to Excel Charts

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+