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
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