On the chart, double click the trendline equation, then select the=20
Number tab. Change the format to something that shows lots of decimal=20
places (scientific with 14 decimal places, for example).

--=20
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article ,=20
says...
I am calculating/plotting a log trendline extract on the equation
y =3D 533371Ln(x) - 3E+06. Ln(x) is the period (extract) number, startin=
g at=20
1 and ending at 288. There are 288 plotted points. The value for 533=E2=
=A4=3D3F and=20
3E=E2=A4=3D3F are derived from the trendline equation each month, when a =
new value (and=20
account balance) is added to the series. The plotted extracted values (y=
)=20
give me an exact duplicate of the Excel log trendline curve, and, a value=
=20
(forcast) for period 288, where the trendline crosses the right side of t=
he=20
chart. The series looks like this, where cell L2 holds the 533 value, M2=
=20
holds the 3E value, and G* is the extract number. Works fine.
=20
=3D(L2)*LN(G1)-M2
=3D(L2)*LN(G2)-M2 =20
=3D(L2)*LN(G3)-M2
etc.
=3D(L2)*LN(G288)-M2
=20
Now I want to do a second series, using a 2nd order poly trendline with t=
he=20
equation y =3D 1.8485x2+641.06x (given by Excel). The extract dimension=
=20
remains 1 through 288, and the series is:
=20
=3D1.8485*(G1)+641.06*(G1)
=3D1.8485*(G2)+641.06*(G2)
=3D1.8485*(G3)+641.06*(G3)
etc.
=3D1.8485*(G288)+641.06*(G288)
=20
The final value (G288) is coming up 183,228, when it should be in the reg=
ion=20
of 340,000, the approximate value where the Excel-plotted trendline cross=
es=20
the right side of the chart.
=20
Where is the logic flaw?
=20
=20