Use a Trendline Formula to Get Values for Any Given X with Excel
- by kirkouimet
Is there an easy way to apply the trend line formula from a chart to any given X value in Excel?
For example, I want to get the Y value for a given X = $2,006.00. I've already taken the formula and retyped it out be:
=-0.000000000008*X^3 - 0.00000001*X^2 + 0.0003*X - 0.0029
I am continually making adjustments to the trend line by adding more data, and don't want to retype out the formula every time.