Data range reference in a cell

C

Craig

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top