Trendlines in Excel
 

I would like to use the equation of a trendline through a set of datapoints
to interpolate a value from a chart in Excel. Is there a way to pull the
trendline equation into a cell to return a value? The data set could change,
so entering an equation for the trendline will not really work well. Any
help would be appreciated.

See
Trendline coefficients
http://www.tushar-mehta.com/excel/ti...efficients.htm

as well as the lightly tested
http://groups-
beta.google.com/group/microsoft.public.excel.charting/browse_thread/thr
ead/3186b43d9dc84ebd/0eda30f29434786d?q=trendline+group:
*Excel*+author:tushar&rnum=1&hl=en#0eda30f29434786 d
--
Regards,

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

In article ,
says...
I would like to use the equation of a trendline through a set of datapoints
to interpolate a value from a chart in Excel. Is there a way to pull the
trendline equation into a cell to return a value? The data set could change,
so entering an equation for the trendline will not really work well. Any
help would be appreciated.