Mike,

Thank you for your help. I was already using an XY Scatter chart type. I
increased the number of decimal places to 14. The equation got a little
messier, and the R*R value went down ever so slightly, but the created
function now matches the data.

"Mike Middleton" wrote:

Tom21 -

(1) Use more significant digits for your calculations. (A) Select the
trendline equation on the chart, and press the Increase Decimal button
repeatedly, or (B) use worksheet formulas, like INTERCEPT, SLOPE, or LINEST
for your calculations.

(2) Use an XY (Scatter) chart type. If you use a Line chart type, Excel uses
X values of 1,2,3,... for the calculations.

(3) Give us more information about the data, the chart type, and the
trendline Trend/Regression type you are using.

- Mike
www.mikemiddleton.com

"Tom21" wrote in message
...
I am taking known data (4 points) and creating a trendling. I am selecting
the option to show the formula and R*R value, which is 1.0. I am charting
this equation and comparing it to the data used to create the formula, and
to
the chart used to derive the formula. They are very different. Can I
correct
this situation? If so, how? I have checked to make sure that I typed in
the
correct formula. Where do I go from here?