How do you read points on trendlines in Microsoft Excel?

Is there any possible way that you can read the points on the trendlines you create in Microsoft Excel? If you need me to elaborate, I will, but please try to help.

How do you read points on trendlines in Microsoft Excel?
No, you can't read the points directly. The way to do it is to generate the formula for the trendline outside of the chart, and then plug in an X value to calculate the Y value.





Suppose that your original X data is in A1:A5, and your Y data for the chart is in B1:B5. Now, say that you want to know what Y would be if X is 25. Go to a blank cell, say C1, and enter 25. Now, in D1 to get your Y variable (assuming a linear trendline) you could use this formula:





=intercept(B1:B5,A1:A5) + C1*slope(B1:B5,A1:A5)





That will do it. You could, instead, use the Forecast() function, and probably the Trend() function.





Note that if you format the trendline in the chart, you can have Excel put the equation of the line in the chart. However, you shouldn't take that equation and enter it into a worksheet formula. You will likely introduce small errors due to rounding.





Tim


http://www.tvmcalcs.com