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 ,
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"