Now we are getting there but we need to make a few more formatting adjustments. Hi problem is that I dont have the data to make that specific slope. Click the Display Equation on chart check box to add the equation to the graph.
Suppose we have the Xs values located in the excel sheet range from A1 to A10 and Ys values located in the given excel sheet from range B1 to B10 then we can calculate the SLOPE here by using the below VBA functions.
That equation includes a slope and intercept value. Each linear regression trendline has its own equation and r square value that you can add to the chart. Check the box labeled Display Equation on Chart and then close the window. Click the Display Equation on chart check box to add the equation to the graph.