Charts - Trends - Excel Formula

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!!
 
T

Tushar Mehta

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

changing trend/series data by manipulating chart lines? 1
Trend lines in charts under Excel 1
PowerPoint Embed scroll excel chart and data in powerpoint 0
Seasonal Trend Lines 4
Sin function trend line 1
Problem creating a logarithmic trend line 2
How do I add a trend line to a stacked chart in Excel 1
chart menu 1

Top