First off, is this question appropriate for this Stack Exchange? If not, I'll remove it.
Now to my question:
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.