Charts and formulas

Hello, first time poster here.

My question is, when I put in a series of points and make a chart, then proceed to use the ability to get a best fit, and it comes up with the formula (y=1111x +1111) for example, is there any way to automatically use that formula in excel?

For what I am doing, the ability to then use the formula and automatically link it back into excel would be quite helpful in trying to get it to plot a best fit line, then take the formula automatically and apply it to get a few other results.

Thanks,
Greg

That helps thanks.

Now, I am having a bit of trouble getting it to return the right data. I've been wrapping my head around it and can't quite seem to get it.

I only have two columns of data, one for the x value and one for the y. Basically a calibration that will determine error, however for completion I need to see the numbers.

So, on that note, on your formula (y=mx+b) I would like Excel to be able to return the 'm' and 'b' values so I can use them. For some reason all my math training seemed to go blank in my head over the last few days.

Oh, now I feel like an idiot. I was mixing up the x and y values, no wonder the returns on the numbers were way off.

Thanks guys, that helped a bunch...wow, feel kinda silly