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.