software

Hi..

I use Business Objects at work - an old version - and trying to apply
trends to charts created (I know so far not excel related - please read
on!!)

I can do it by creating home made calulations, but need to know if
anyone would know the actual formula excel would apply when you click
on the add trends line in the charts options???

Help!!--
Siggsy007
------------------------------------------------------------------------
Siggsy007's Profile: www.excelforum.com/member.php...oamp;userid=14529
View this thread: www.excelforum.com/showthread...hreadid=510532XL calculates the coefficients based on the kind of trendline you want. It
does so by minimizing the sum of squares of the errors.

--
Regards,

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

In article gt;,says...
gt;
gt; Hi..
gt;
gt; I use Business Objects at work - an old version - and trying to apply
gt; trends to charts created (I know so far not excel related - please read
gt; on!!)
gt;
gt; I can do it by creating home made calulations, but need to know if
gt; anyone would know the actual formula excel would apply when you click
gt; on the add trends line in the charts options???
gt;
gt; Help!!
gt;
gt;
gt; --
gt; Siggsy007
gt; ------------------------------------------------------------------------
gt; Siggsy007's Profile: www.excelforum.com/member.php...oamp;userid=14529
gt; View this thread: www.excelforum.com/showthread...hreadid=510532
gt;
gt;


I need calcualtions for the linear trend...--
Siggsy007
------------------------------------------------------------------------
Siggsy007's Profile: www.excelforum.com/member.php...oamp;userid=14529
View this thread: www.excelforum.com/showthread...hreadid=510532