The old Google Groups will be going away soon, but your browser is incompatible with the new version.
Message from discussion Excel8; macro to get trendline equation of graph in a cell

From:
To:
Cc:
Followup To:
Subject:
 Validation: For verification purposes please type the characters you see in the picture below or the numbers you hear by clicking the accessibility icon.

More options Sep 13 1998, 3:00 am
Newsgroups: microsoft.public.excel.misc
Date: 1998/09/13
Subject: Re: Excel8; macro to get trendline equation of graph in a cell
Marcel,

>I'll try the LINEST function as well as your macro.
>I thought that LINEST only performs a linear regression, so a regression
>that yields y=mx+n. Obviously it also works for polynomials.
>But does it also work for LN, e-power and x-power equations?

Yes. For example, coeffiecients for a logarithmic trendline come from:

=LINEST(B1:B20,LN(A1:A20),,TRUE)

"Power" trendline:

=LINEST(LN(B1:B20),LN(A1:A20),,TRUE)

"Exponential" trendline:

=LINEST(LN(B1:B20),A1:A20,,TRUE)

(You will likely need to use the EXP() function on the constant
returned by LINEST in the case of the "power" and "exponential"
trendlines.)

Of course, that's just my opinion. I could be wrong.

C^2