Data range reference in a cell
 

Hi

I'm working with a large number of data ranges and i want to be able to
change the source data of one chart by typing the range name in a cell rather
than directly into the chart source tab.

For example: in B1 i've typed "SCK" (which is defined as a range on another
sheet)
I want to be able to change B1 to read "JAB" and the chart to change it's
source data to the JAB range which is also defined.

Thanks