Find the Equation of a Trendline in Excel

You should use a trendline formula only with XY Scatter chart, because this chart plots on both X and Y axis as values, contrary to other charts, like Column, Line, or Bar, which plots only on the Y axis as values. Therefore, the trendline won’t be accurate for these types of charts.

Find the equation of a trendline

In order to display the Equation of a trendline, follow these steps.

  1. Select all data inside a table.
  2. Navigate to Insert >> Charts and select Scatter Chart.
  1. Right-click the Data Series and select Add trendline.
  2. Select the trendline type.
  3. Check Display
    Equation on the chart

Depending on the trendline type, you are going to get different types of equations.

After you add the equation, you can change its position by dragging.

Tomasz Decker is an Excel specialist, skilled in data analysis and financial modeling.