trendline equation extract

[Guest]

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"

 

[Jerry W. Lewis]

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/[email protected]

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

 

[Tushar Mehta]

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

--
Regards,

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

 

[Jerry W. Lewis]

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

Jerry

 

[Guest]

thanks alot jerry

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/[email protected]

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

 

[Tushar Mehta]

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

 

[Jerry W. Lewis]

You're welcome. Glad it helped.

Jerry