Dheer,

Double-click on your trendline, go to Options - Display Equation on Chart.
Once Excel displays the equation, substitute some number for X to calculate Y
to get a point value. Typically, you could substitute 1, 2, 3, 4, 5, 6, 7, 8
.. . . etc. for X to get a series of corresponding Y values. If you plotted
those XY values, they should mirror your trendline.

----
Regards,
John Mansfield
http://www.pdbook.com



"Dheer" wrote:

I created a polynomial trendline for a sales forecast. How do i figure out a
appriximate value for a point on the trendline