Hi all,

I have a Choose function that is used to determine which range I need. e.g. =Choose(Choice,Cell,Cell,...).

In each corresponding "Choice" cell is a typed range. e.g. $B$33:$L$70

I'm looking for a way to be able to use this typed range as the range for some chart data.

Is this possible and how would it be done?

Hopefully the question is clear, but if not, i'll try to answer further questions.

Cheers