Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to link trendline equation in graph to cell? | Excel Discussion (Misc queries) | |||
Linear Trendline Equation Question | Charts and Charting in Excel | |||
Rounding in Trendline Equation | Charts and Charting in Excel | |||
Logarithmic Trendline Equation | Charts and Charting in Excel | |||
How do I get the trendline equation from Excel to script? | Charts and Charting in Excel |