David Braden's TLCoef() functions

  • Thread starter Thread starter Kevin Sprinkel
  • Start date Start date
K

Kevin Sprinkel

I downloaded the subject functions to extract the
coefficients of quadratic and logarithmic trendlines.
After saving as an Add-In, the functions are now
available.

I am getting a VALUE error for the following function:

Function TLcoef(vSheet, vCht, vSeries, vTL)

vSheet Worksheet name or number
vCht Name or Number of the Chart
vSeries Name of the Series
vTL Series' trendline number

when called: =TLcoef("Regression",1,"KnownY",1)

where KnownY the name of the series' range.

Does anyone know what I'm doing wrong?

TIA
Kevin Sprinkel

when called =TLcoef(
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Paging David Braden Re: Regression 12
Macro for multiple charts 3
Trendline Coefficients 3
Re : Excel VBA Charting of a Trendline, the Parameters do not Tally with the Calculations obtained b 2
How to fit a "ln" function 2
How do I change the legend text in Access 2002 chart? 3
Trendline values 2
Function for Logarithmic Trendline 9

Back
Top