Getting Trend Line Info from Chart

Instead of
LN(range)
use
If(ISNUMBER(range),LN(range))
and array enter the formula.

Jerry

"Carrie_Loos via OfficeKB.com" wrote:

> Thanks and sorry I should have been clear in defining my issues. I have
> reposted the issue under Dynamic Range Name in Functions. It's true the
> defined names work as long as I have a set range but the values change and if
> there is a blank then I get the #VALUE! error. So I am trying to get a
> dynamic range to work but so far I have not been successful.
>
> Mike Middleton wrote:
> >Carrie -
> >
> >You can use defined names Xrange and Yrange to refer to the numeric data
> >ranges on your worksheet. And if you change the Refers To range of both
> >defined names, the formulas will update. In Excel 2003, choose Insert | Name
> >| Define.
> >
> >- Mike
> >
> >> By the way, can you use a dynamic range name for the Xrange & Yrange? I
> >> can't
> >[quoted text clipped - 19 lines]
> >>>>>> Thank you in advance for any asssistance.
> >>>>>> Carrie
>
> --
> Message posted via http://www.officekb.com
>
>

Not sure if I did this correctly but it came up with a zero value =IF
(ISNUMBER($E$4:$E$103),LN($E$4:$E$103)) - entered as an array formula,
correct? This is the X range. It represents the number of units in sequential
order. So that the range is a possible 100 vaules and I currently have 1 - 82
in the range. The rest or the range are true blank cells.

Jerry W. Lewis wrote:
>Instead of
> LN(range)
>use
> If(ISNUMBER(range),LN(range))
>and array enter the formula.
>
>Jerry
>
>> Thanks and sorry I should have been clear in defining my issues. I have
>> reposted the issue under Dynamic Range Name in Functions. It's true the
>[quoted text clipped - 16 lines]
>> >>>>>> Thank you in advance for any asssistance.
>> >>>>>> Carrie

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.aspx/excel-chart/200808/1