how to add trendline in excel

Premium Excel Course Now Available!

Build Professional - Unbreakable - Forms in Excel

45 Tutorials - 5+ Hours - Downloadable Excel Files

Instant Access! - Lifetime Access!

Add, Manage, & Remove Trendlines in Charts in Excel

Add to Favorites Favorited

How to add, manage, and remove trendlines in Excel

Trendlines allow you to show trends in charts that might be otherwise difficult to notice. Basically, this is mostly used as a visual aid to illustrate an upward, downward, or flat trend over varying data points in a chart.

Sections:

Add a Trendline to a Chart

Manage a Trendline

Remove a Trendline

Notes

Add a Trendline to a Chart

Select the desired chart by clicking it.
Three tabs should then appear, go to the Layout tab and click Trendline

You can select a Trendline option from the drop down menu or, if you want more control over the Trendline, click More Trendline Options...
If you selected a basic option you are done, otherwise continue to Step 3.
Once you click More Trendline Options, a window will open that allows you to select the type of Trendline and options related to its calculation, display, and appearance.
I will select the basic option Linear; Linear and Exponential are the two most often used options. Then, I want to display the Equation used to generate the Trendline, so I check that option at the bottom of the window.
If you want to change the look and style of the line, select from the categories on the left side of the window: Line Color, Line Style, Shadow, or Glow and Soft Edges.
Hit the Close button at the bottom of the window when you are finished and that's it!

You will notice the mathematical equation that appears to the right of the Trendline. That is the formula used to generate the Trendline and you can move it anywhere on the chart by clicking it and dragging it.

Basically, that is all there is to creating a Trendline in Excel.

Manage a Trendline

To manage a Trendline, you just have to get to the Trendline Options window.

Click the desired chart and then specifically click the Trendline (this is important because you can have more than one Trendline on a chart).
Go to the Layout tab.
Click the Trendline button and then click More Trendline Options...
From the window that appears, you can manage every aspect of the Trendline.

Remove a Trendline

Click the desired chart and then specifically click the Trendline that you want to remove (this is important because you can have more than one Trendline on a chart). If you have only one Trendline on the chart or you want to remove all of them, then you do not need to specifically click a Trendline.
Go to the Layout tab and click Trendline and then click None
That's it!

Notes

Trendlines are features of charts that help you better visualize a pattern or trend so a user can more clearly analyze what is happening with the data. This feature can be quite helpful, especially when the chart by itself doesn't clearly convey the trend that you want to show, but you probably don't need to use a Trendline on every chart or else you will just annoy people and it won't actually be helpful.

Download the spreadsheet that accompanies this tutorial to see the above example in Excel.

Question? Ask it in our Excel Forum

Our Excel Courses

Professional Input Forms in Excel

Skill Level: All Levels
|
5 hours+

How to make a fully featured professional form in Excel that is unbreakable. This includes how to use the form to store, view, edit, and delete data from a data storage worksheet.

Send Emails from Excel (Multiple Methods)

Skill Level: All Levels
|
2 hours

Send Emails from Excel using VBA and Macros. This course starts from the Basics and builds up to more advanced examples with attaching workbooks, worksheets, PDF's, automatically sending emails, including a signature, error handling, increasing speed, and more.

Subscribe for Weekly Tutorials

BONUS: subscribe now to download our Top Tutorials Ebook!