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

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

Expanding on Bernard's suggestion about LINEST, see
Trendline coefficients
http://www.tushar-mehta.com/excel/ti...efficients.htm

As far as Dave's code goes, I posted a revised version that corrected
certain limitations. See
http://groups.google.com/group/micro...ting/msg/0eda3
0f29434786d


--
Regards,

Tushar Mehta
www.tushar-mehta.com
Multi-disciplinary business expertise
+ Technology skills
= Optimal solution to your business problem
Recipient Microsoft MVP award 2000-2005

In article ,
says...

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