Thanks Jerry.

Jerry W. Lewis wrote:
http://groups.google.com/groups?selm....microsoft.com


If you still have problems, the Google link from my post in the
"Trendline equation in chart is wrong" thread (Nov 2003) should work.

Jerry

Andy Pope wrote:

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, Microsoft MVP - Excel
http://www.andypope.info