Yes, I see what you mean.
BTW: the problem also occurs when you copy to the SAME Excel file
I get the same coefficients with LINEST as reported by Jerry
Sorry to reply so late
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Charles @ Aldenlab" wrote in
message ...
Sure....use this data

x y
1252.531345 44.0462161
1399.141231 54.03976206
1400.056416 44.5415568
1398.717824 36.45095719
1121.321671 69.02084478
1120.421493 57.35527023
1121.880135 58.10791134
1015.828469 52.80347407
842.7187937 73.74794476
755.8568419 69.50308062
841.0183109 68.54248481
560.0202985 81.17169689
503.6105019 79.47102425
560.4900412 81.38340795
281.0801761 94.02451592
252.2988083 96.7705903
281.3767037 92.81489618
0 100

Plot that data on an XY Scatter Plot in Excel 2007.

Select the series, then right click and "Add Trendline"

Use the following properties for the trendline:

Trend/Regression Type:
Polynomial - Order 3

Trendline Name:
Automatic

Check Set Intercept = 100
Check Display Equation on chart
Check Display R-squared value on chart

You will get an equation:
y = 6E-09x3 - 3E-05x2 - 0.021x + 100

Now, copy the chart and paste it into another Excel 2007 document, Word
2007, Powerpoint 2007, ect. document and note the equation. It will
change
to the following:
y = - 3E-05x2 - 0.021x + 100

This is the previous equation minus the x^3 term. If you check the
Trendline properties, they are all still set as they where in the original
chart. The only way to get the equation working correctly again is to
remove
then readd the trendline.

I hope you can reproduce this error, this occures on all of our Office
2007
installations here, Pro Plus and Standard about 40 copies. If there are
others in the engineering world experiencing this problem, and not
noticing
it, there could be serious concequences for the projects they are working
on.

"Bernard Liengme" wrote:

I was unable to reproduce this behaviour. Can you give more details?
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Charles @ Aldenlab" <Charles @ wrote
in
message ...
In Excel 2007 if you create a XY Scatter Plot and then add a polynomial
trendline to the plot, display the equation, then try and copy/paste
the
chart to a Word 2007 document the trendline equation in the chart drops
one
of the orders. If you right click and select Format Trendline, it
still
lists the correct order equation, but it does not show. If you delete
the
trendline, and then add it again in the pasted copy of the chart the
problem
is fixed. I have reproduced this using 2,3,4,5, and 6th order
polynomial
equations.