How do I write a trendline constant into a cell?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Hanbotkot - 31 Dec 2004 02:31 GMT

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.

Reply to this Message

Jon Peltier - 31 Dec 2004 06:00 GMT

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 here:

http://groups-beta.google.com/group/microsoft.public.excel.misc/browse_frm/threa
d/edb681e63ba3bf2d/4d440d271303e0d6

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

> Trendline equation constants.
>
[quoted text clipped - 5 lines]
> This is needed when the data producing a trendline, can change and thus have
> an effect through the page.

Reply to this Message

Michael R Middleton - 31 Dec 2004 17:27 GMT

Hanbotkot -

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

- Mike

www.mikemiddleton.com

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

> Trendline equation constants.
>
[quoted text clipped - 6 lines]
> have
> an effect through the page.

Reply to this Message