Then, from the available options select Scatter.Next, go to the Insert tab and click on the Insert Scatter (X, Y) or Bubble Chart dropdown.First, select the dataset with the help of the mouse.
Let us see how to find the equation from a single trendline. This type of trendline is applicable to various real-life cases. Find Equation with Single Trendline in Excelįor simple excel datasets, you can use a single trendline to fit your data and then find its equation.
3 Suitable Ways to Find the Equation of a Trendline in Excel 1.