Step_3: Next, select the Scatter plot from the Charts group. Step_1: First, select the cell range A1:B10. I will show you the method of adding the linear trendline and its equation. The dataset represents the linear change of the variables. In this dataset, the column Study Hours showed the hours I spent studying, along with the test results in the column Test Score.Įasiest Way to Add Trendline Equation in Excel Easiest Way to Add Trendline Equation in Excel.
