Hi,

Am Wed, 25 Jan 2017 13:58:04 -0800 (PST) schrieb BottleMan:

With the formula you provided the y-values are like this:
x-Axis Y-axis
1.2 -1.175283891
1.6 -3.196520141
2.4 -12.23920302
3.6 -44.71833352
4.8 -109.1028104
6 -215.2796
7.2 -373.5357904
8 -513.4864
Much worse. Can you show me what you got?

when you change the values you have to play around with the trendline
properties to smooth the trendline to you data.
With the values above it is enough to have a formula with 3ed order:
y = -0,9906x3 - 0,3113x2 + 1,8738x - 1,2828



Regards
Claus B.
--
Windows10
Office 2016