How to Find the Equation of a Trendline in Excel (3 Methods)

 

Method 1 – Single Trendline

Steps

  • Choose your dataset using the mouse.
  • Go to the Insert tab and select Scatter from the Insert Scatter (X, Y) or Bubble Chart dropdown.
  • This will create a scattered chart with your data points.

Find Equation with Single Trendline in Excel

  • Right-click on any chart point and choose Add Trendline.

Find Equation with Single Trendline in Excel

  • In the Format Trendline window, select Linear as the trendline option.

Find Equation with Single Trendline in Excel

  • Check Display Equation on Chart to see the equation.

  • You should see a trendline on your chart with the equation.

Read More: How to Find the Equation of a Line in Excel


Method 2 – Use Double Trendline

When you have an Excel dataset that has different categories of data points, you can use this method to find the equation of a trendline.

how to find the equation of a trendline in excel

Steps

  • Select your dataset and create a scatter plot (similar to the one shown below).

how to find the equation of a trendline in excel

  • Right-click on the chart and choose Select Data.

how to find the equation of a trendline in excel

  • In the new Select Data Source window, select the data series Y and click Remove.

how to find the equation of a trendline in excel

  • A new Edit Series window will open.
  • Click Add and create a new data series named Linear.
  • Select cells B5 to B7 as the Series X values.
  • Select cells C5 to C7 for the Series Y values.
  • Press OK.

how to find the equation of a trendline in excel

  • Create another dataset with the name Polynomial.
  • For the Series X values select cells B8 to B10, and for Series Y values select cells C8 to C10.

  • You will see a scatter plot of the two data series we just created.

  • Right-click on any of the blue data points and select Add Trendline.

  • Follow the steps from Method 1 to display the Linear trendline equation.
  • Repeat for orange data points using the Polynomial option.


Method 3 – Column Chart Trendline

Steps

  • Select your data and go to the Insert tab.
  • Click on the Insert Column or Bar Chart dropdown and select the Clustered Column option.

Find Equation from Excel Column Chart Trendline

  • Excel will generate a 2-D clustered column chart.

Find Equation from Excel Column Chart Trendline

  • Right-click on any of the orange-colored columns and select Add Trendline.

Find Equation from Excel Column Chart Trendline

  • In the new Format Trendline window, choose Polynomial as the Trendline Options.

  • Check Display Equation on Chart option to see the polynomial equation.


Download Practice Workbook

You can download the practice workbook from here:


Related Articles


<< Go Back To Trendline Equation Excel | Trendline in Excel | Excel Charts | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!
Nazmul Hossain Shovon
Nazmul Hossain Shovon

Nazmul Hossain Shovon, a BUET graduate in Naval Architecture and Marine Engineering, embarked on his career with 8 months dedicated to the Exceldemy project's triumph. Transitioning into a Software Developer role, he specialized in web add-in development. At Exceldemy, he authored about 125 blog articles and solved many visitors’ problems, refining his writing skills and delving into Excel-related topics. With a primary passion for programming and software development, Shovon continually explores new horizons, fostering professional growth in his... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo