Charts - Trends - Excel Formula

  • Thread starter Thread starter Siggsy007
  • Start date Start date
S

Siggsy007

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!!
 
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
 
Back
Top