extracting the trendline equation
I am currently trying to use Dave Brendans code as I would like to base formulas on the trendline of the graph so that it will change when certain information is filtered. However I am unable to make the code work, not being particularly adept at vb I was just after a little clarification if you would be so kind. I have pasted the code into a worksheet and checked all comments are on the correct lines etc. When I type in =TLcoef(12!,1,1,1) I get an error on the graph section of the formula. Is my syntax correct? (I only have one graph, series and trendline) -- Will1 ------------------------------------------------------------------------ Will1's Profile: http://www.excelforum.com/member.php...o&userid=29101 View this thread: http://www.excelforum.com/showthread...hreadid=189077 |
extracting the trendline equation
Why not use LINEST?
-- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Will1" wrote in message ... I am currently trying to use Dave Brendans code as I would like to base formulas on the trendline of the graph so that it will change when certain information is filtered. However I am unable to make the code work, not being particularly adept at vb I was just after a little clarification if you would be so kind. I have pasted the code into a worksheet and checked all comments are on the correct lines etc. When I type in =TLcoef(12!,1,1,1) I get an error on the graph section of the formula. Is my syntax correct? (I only have one graph, series and trendline) -- Will1 ------------------------------------------------------------------------ Will1's Profile: http://www.excelforum.com/member.php...o&userid=29101 View this thread: http://www.excelforum.com/showthread...hreadid=189077 |
All times are GMT +1. The time now is 05:09 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com