I suppose so... {grin}
On a related topic, maybe you missed my post of the code for extracting
the trendline data to a worksheet. Or, maybe you didn't but have been
busy. In any case, the link:
http://groups.google.com/group/micro...rting/msg/0eda
30f29434786d?dmode=source&hl=en
And, of course, you are welcome to use either email or the NG for
followups.
--
Regards,
Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
In article ,
says...
Since the OP is comparing LINEST with the chart trendline, he must have
already plotted the data. On the assumption that he actually looked at
the plot that he produced, I can only assume that he is interested in
the numerics of the fitting process, not the quality (or lack thereof)
of this particular fit.
Jerry
Tushar Mehta wrote:
If you plot the data you will quickly see that the only trend is a flat
horizontal line or, with the application of a fair dose of imagination,
a slight downward sloping trend.