Something I have discovered for long but which continues with Excel
2007 (under XP): when you draw a trend line in a scatter or line chart
I generally get either not the best fit (or equation) and/or almost
sytematically the wrong equation associated to this trend line.

Has anybody seen that already and moreover knows why it is like that?
Surprising from a company like Micosoft.