How to Add a Trendline in Excel





The interactive transcript could not be loaded.



Rating is available when the video has been rented.
This feature is not available right now. Please try again later.
Published on Apr 7, 2013

This tutorial will show you how to easily create a trendline in Excel.

Don't forget to check out our site http://howtech.tv/ for more free how-to videos!
http://youtube.com/ithowtovids - our feed
http://www.facebook.com/howtechtv - join us on facebook
https://plus.google.com/1034403827176... - our group in Google+

A trendline can be a valuable indicator on a graph. This tutorial will show you how to easily add trendline excel chart.

Step # 1 -- Opening the Data

Open Excel and make sure that you have a graph with some data included. Trendlines are most often added to scatter graphs and they look most effective in this format. As you can see here we have some data in the graph that certainly does follow a trend.

Step # 2 -- Accessing the Trendline Options

Right click on anyone of the points on the graph and in the menu that appears click "Add Trendline". The "Format Trendline" window will appear and you will have several options. The most popular type of line to add is the "Linear" trendline and this is selected by default -- you will also see that it has been added to your graph.

Step # 3 -- Viewing Other Trendlines

Click on some of the other trendlines and the line on the graph will automatically be changed to reflect this option change. Here we are sticking with the linear line so select this and click "Close". This is how to add trendline excel graph.


When autoplay is enabled, a suggested video will automatically play next.

Up next

to add this to Watch Later

Add to

Loading playlists...