If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Basic questions on transitioning from Excel to Acces - charts &rep | PZ Straube | Setting Up & Running Reports | 0 | May 17th, 2005 07:25 PM |
EDIT FORMULA BAR in excel 2003? why not? where is it? | alnav89 | Worksheet Functions | 2 | April 26th, 2005 07:02 PM |
Windows in Taskbar | Chevy | General Discussion | 8 | October 15th, 2004 03:57 PM |
Excel Formula | yuki | Worksheet Functions | 7 | September 28th, 2004 02:40 AM |
Excel creates its own hidden charts that creates a corrupt file! | FlawedLojik | General Discussions | 0 | August 29th, 2004 05:43 PM |