Polynomial Trendline Issues

Hello,

For my excel project, I'm plotting data from a profilometer program.

What I'm trying to do is get a trendline for my given data, put the equation for the trendline and plug in the X values, and compare the given data to the trendline inputted data.

The problem is that for whatever reason, the trendline equation is incorrect.
I plotted the data I have with the trendline on top of it, and then plotted X vs. the Trendline data; it comes out completely different.

I've attached my file, can anyone see what the hell is going on?

[Note: there is a lot of data so please be patient as it does freeze up computers for a minute or two
Also since my file was too big, I saved it as a binary excel file (.xlsb) but since you don't allow that on your site, I renamed it to a .xls file; It will say it may be corrupted but opens fine]

I'm not trying to make a straight line, but a polynomial line [right now I'm using a 6th order polynomial equation because it yields the highest R^2 value]

I've linked the file; its bigger than the allowable upload size for this website

http://www.filehosting.org/file/deta.../Sample_A.xlsx

[This may look sketchy but I tested it a few times and the file is virus free]

http://rapidshare.com/files/22463330...le_A.xlsx.html
try this one

Is everything supposed to have the "#VALUE" sign around ? I'm confused as to what you did; I need all of the data points in order to conduct analysis