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 chart.

## Find the equation of a trendline

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

- Select all data inside a table.
- Navigate to
**Insert >> Charts**and select**Scatter Chart**.

- Right-click the Data Series and select
**Add trendline**. - Select the trendline type.
- 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.