Charts - Trends - Excel Formula
 

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: http://www.excelforum.com/member.php...o&userid=14529
View this thread: http://www.excelforum.com/showthread...hreadid=510532

Charts - Trends - Excel Formula
 

XL 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 ,
says...

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: http://www.excelforum.com/member.php...o&userid=14529
View this thread: http://www.excelforum.com/showthread...hreadid=510532

Charts - Trends - Excel Formula
 

I need calcualtions for the linear trend...


--
Siggsy007
------------------------------------------------------------------------
Siggsy007's Profile: http://www.excelforum.com/member.php...o&userid=14529
View this thread: http://www.excelforum.com/showthread...hreadid=510532