How do I write a trendline constant into a cell?
 

Trendline equation constants.

A trendline has been drawn on a chart and an acceptable equation has been
obtained. The constants in this equation must be used in other formulas.

How are these constants written into cells that can be used in formulas?

This is needed when the data producing a trendline, can change and thus have
an effect through the page.

You can get this using the worksheet array function LINEST (see the help files), or
by parsing the formula using Dave Braden's code, posted he

http://groups-beta.google.com/group/...440d271303e0d6

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______


Hanbotkot wrote:

Trendline equation constants.

A trendline has been drawn on a chart and an acceptable equation has been
obtained. The constants in this equation must be used in other formulas.

How are these constants written into cells that can be used in formulas?

This is needed when the data producing a trendline, can change and thus have
an effect through the page.

Hanbotkot -

If it's a simple linear fit, you can use the INTERCEPT and SLOPE worksheet
functions.

- Mike

www.mikemiddleton.com

++++++++++++++++++++++++

"Hanbotkot" wrote in message
...
Trendline equation constants.

A trendline has been drawn on a chart and an acceptable equation has been
obtained. The constants in this equation must be used in other formulas.

How are these constants written into cells that can be used in formulas?

This is needed when the data producing a trendline, can change and thus
have
an effect through the page.