Getting chart range from range address contained in a cell

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

You would normally use the INDIRECT function to convert that text value into a range that Excel can operate on. However, I'm not very sure what you want to do with it - maybe an example workbook might make it clearer.

Hope this helps.

Pete

I tried using the indirect function for the graph, but it wouldn't have a bar of it...

Attached is the cut down version.

Forum Question.xlsx

Basically I need the series data to be selected based on the range found within the cell.

There is mulitple and large data sets, and the best way I thought to get the correct data set was to use the range information.

Cheers