Trendline Cell Reference?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello.

I am attempting to place a reference in Excel to the calculated trendline in
a Graph, and so far have had no luck.

Is this even possible?

If so, what is the code for this?

I'm at the point that I would even accept some sort of VBA code that I could
use to display this same information.

I don't want to recalculate the trendline in the cell, I would just want to
reference the existing calculations.

Thanks in advance.
 
Alternately, David Braden has posted VBA code to extract the
coefficients directly from the chart into cells

http://groups.google.com/[email protected]

The advantage of using the chart coefficients (either manually or via
Braden's code) is that LINEST (prior to Excel 2003) uses a numerically
inferior algorithm that can give inaccurate results with some data sets.
The chart trendline (extracted by Braden's code) is much better
numerically, but would require VBA event programming to auto update.

Jerry
 
Back
Top