On Friday, January 20, 2017 at 1:22:05 PM UTC-5, BottleMan wrote:
Hi everybody,

I use scatter charts and trendlines a lot to derive formulas from real data. Excel then prints the formula it used on the chart. However, when I use this formula with the same data set the values always differ and I have to massage the formula to make it represent the data. What am I doing wrong here?
Thanks for your help.

Well, playing around with the data is what I have been doing but I don't understand why Excel would give me a formula that does not work even though the trendline it draws hugs the values very well!