Skip to content
Related Articles

Related Articles

Improve Article

How to Add Trendline to Excel?

  • Last Updated : 13 Apr, 2021

A trendline is an additional line that indicates the slope (or trend) in a particular data series and is also known as a line of best fit. Trend lines can be helpful when you are analyzing data because they can forecast future values based upon your current data.

Implementation:

Follow the below steps to add Trendline in Excel:

Step 1: Select a Chart.            

Select the chart just by clicking on it.

Step 2: Now, click on the CHART ELEMENTS (PLUS icon) in the upper right corner of the chart.



Step 3: From CHART ELEMENTS select the TRENDLINE option.

Trendline is applied.

Step 4: You can FORMAT TRENDLINE also by further clicking on the trendline arrow.

A new bar like this will pop out

Step 5: Now click on More Options… and can select any option from the list.

You can select from various Trendline Options..

At this point, you have successfully added the Trendline on a chart in Excel

My Personal Notes arrow_drop_up
Recommended Articles
Page :