Hi tep,

What Chart Type did you use?

If Line, change it to (x-y)Scatter to get the right result.

Also, how many points in your data? An R-squared of 0.998 may not mean much
if you do not have sufficient data points.

Ed Ferrero
www.edferrero.com

Using copy and paste I transferred the trendline equation (in this case a
quadratic) from a chart element to a worksheet cell and then subjected it
the
original data to validate it. The resulting values are magnitudes
different
to the orignal data - in the millions, not explained by regression
tolerance,
RHO of 0.998. The x axis values were months - what value does Excel assign
to
months in Charts because the 1900 system values (eg 39643 for 14 Jul 2008)
do
not appear to be ones used?