trendline equation extract

i have a group of charts drawn with trendlines , i have the equations of
these trendlines shown on the charts, question is :how can i extract the
trendline function displayed on the chart and use it on another routine...
i.e. i want the code that calls the trendline function equation... if there
is such thing??..please help! "vb6"

You can generally get the equations from the LINEST and/or LOGEST
worksheet functions. Alternately, David Braden has posted VBA code to
extract the coefficients directly from the chart into cells

http://groups.google.com/groups?selm....microsoft.com

In some instances the chart trendline coefficients will be more accurate
than LINEST/LOGEST. However, to do accurate calculations based on the
coefficients displayed on the chart, you have to display those
coefficients in scientific notation with 14 decimal places, otherwise
you may loose accuracy due to rounding.

Jerry

kafoury123 wrote:

> i have a group of charts drawn with trendlines , i have the equations of
> these trendlines shown on the charts, question is :how can i extract the
> trendline function displayed on the chart and use it on another routine...
> i.e. i want the code that calls the trendline function equation... if there
> is such thing??..please help! "vb6"

thanks alot jerry

"Jerry W. Lewis" wrote:

> You can generally get the equations from the LINEST and/or LOGEST
> worksheet functions. Alternately, David Braden has posted VBA code to
> extract the coefficients directly from the chart into cells
>
> http://groups.google.com/groups?selm....microsoft.com
>
> In some instances the chart trendline coefficients will be more accurate
> than LINEST/LOGEST. However, to do accurate calculations based on the
> coefficients displayed on the chart, you have to display those
> coefficients in scientific notation with 14 decimal places, otherwise
> you may loose accuracy due to rounding.
>
> Jerry
>
> kafoury123 wrote:
>
> > i have a group of charts drawn with trendlines , i have the equations of
> > these trendlines shown on the charts, question is :how can i extract the
> > trendline function displayed on the chart and use it on another routine...
> > i.e. i want the code that calls the trendline function equation... if there
> > is such thing??..please help! "vb6"
>
>

You're welcome. Glad it helped.

Jerry

kafoury123 wrote:

> thanks alot jerry

You may also want to look at an (incomplete) article:
Trendline coefficients
http://www.tushar-mehta.com/excel/ti...efficients.htm

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article <B34A6174-E8A1-42ED-B35E-2493E67D6F03@microsoft.com>,
kafoury123@discussions.microsoft.com says...
> i have a group of charts drawn with trendlines , i have the equations of
> these trendlines shown on the charts, question is :how can i extract the
> trendline function displayed on the chart and use it on another routine...
> i.e. i want the code that calls the trendline function equation... if there
> is such thing??..please help! "vb6"
>

You should try viewing this page from Netscape as well as IE. As
currently coded, most of the equations are illegible in Netscape.

Jerry

Tushar Mehta wrote:

> You may also want to look at an (incomplete) article:
> Trendline coefficients
> http://www.tushar-mehta.com/excel/ti...efficients.htm

Hi Jerry,

Actually, my browser of choice is Firefox and until your post I hadn't
viewed the page with IE. In the former the equations appear bold but
are otherwise legible. In the latter the equations appear normal.

FWIW, the original is a Word document that was exported as a web page
from within Word. The equations are Equation Editor objects. I will
see if the MS tool that removes Office specific code from a web page
improves the quality of the display.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article <423C6842.9030209@no_e-mail.com>, post_a_reply@no_e-mail.com
says...
> You should try viewing this page from Netscape as well as IE. As
> currently coded, most of the equations are illegible in Netscape.
>
> Jerry
>
> Tushar Mehta wrote:
>
> > You may also want to look at an (incomplete) article:
> > Trendline coefficients
> > http://www.tushar-mehta.com/excel/ti...efficients.htm
>
>