One way would be to use Linest or forecast or slope worksheet functions
against the source data.

You can see how Bernard Liengme solves for the coefficients of a polynomial
curve using LINEST.
http://www.stfx.ca/people/bliengme/E...Polynomial.htm

probably could be adapted to other type curves (an not adpation need for
straight line).

Chip Pearson posted some code to get the values from the chart itself:

http://groups.google.com/groups?thre...GP09.p hx.gbl

--
Regards,
Tom Ogilvy

"Dr.Schwartz" wrote in message
...
When manually adding a trendline to a chart the equation and Rsquared can
be
displayed (DisplayEquation:=True, DisplayRSquared:=True). Is there any way
to
insert these values in two cells instead.

Thanks
The Doctor