Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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
Posted to microsoft.public.excel.charting
|
|||
|
|||
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
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Match then lookup | Excel Worksheet Functions | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
In excel the formula bar behaves differently on different machines | Excel Discussion (Misc queries) |