Hi Jerry,

Can you post that link again, for some reason it's truncated and returns
a Not found @ google.

Cheers
Andy

Jerry W. Lewis wrote:
Alternately, David Braden has posted VBA code to extract the
coefficients directly from the chart into cells

http://groups.google.com/groups?selm...54705032003%40...

The advantage of using the chart coefficients (either manually or via
Braden's code) is that LINEST (prior to Excel 2003) uses a numerically
poor algorithm that can give inaccurate results with some data sets. The
chart trendline (extracted by Braden's code) is much better numerically.

Jerry

Andy Pope wrote:

Hi,

You can get those values via formula, see this explanations.

http://www.stfx.ca/people/bliengme/E...Polynomial.htm
http://tushar-mehta.com/excel/tips/t...efficients.htm

Cheers
Andy

Miguel Saldana wrote:

I believe it will be useful to add an option to Excel that when
adding a tendline to a graph, Excel could ask in which cells it will
store the coefficients and exponents in the resulting trendline. In
this way, the user can use those coefficients in other calculations.



--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info