Hari wrote:
Andy,

Thanks for the post. Indirect not being directly usable in Chart series
is new to me.

Im not sure, but somehow, am still not able to make my formula work.

I have :-

Net_CLI =INDIRECT("Trends!$C$4:$" &
VLOOKUP(COUNTA(Trends!$B$4:$V$4),'Legend Sheet'!$B$31:$C$50,2,FALSE) &
"$4")

and I created a new named range

NetCLI = Choose (1, Net_CLI)

Both of the above named ranges work correctly when I use them in data
validaton (or as an argument within Sum function).

But If I use NetCLI within Values textbox of my chart series (Source
data dialog box) then I get the error which I mentioned before.


Could somebody please outline as to what am doing wrong.

Regards,
HP
India