Author: Oscar Cronquist Article last updated on October 16, 2018

Excel allows you to insert a linear chart trendline that displays a straight line calculated based on the method of least squares of your data series, it is often used in statistical regression analysis.

How to build

  1. Select the chart.
  2. Press with left mouse button on the "plus" sign next to the chart.
  3. Press with left mouse button on checkbox "Trendline".

How to display the linear equation on the chart

  1. Doublepress with left mouse button on the trendline to open the settings pane.
  2. Press with left mouse button on the checkbox "Display Equation on chart".

You can build the linear equation manually in Excel using the SLOPE function to get the slope of the regression line. Use the INTERCEPT function to calculate the point at which the line will intersect the y-axis.