Dynamic 'Chart Data Range'

[LEXCERM]

Hi all,

I have a file which has 20 tabs. In a separate sheet I have a dropdown in cell C2 (which contains the name of each tab) and this produces the following syntax in cell C3:-
'Sheet1'!$I$5:$J$57
'Sheet2'!$I$5:$J$57
'Sheet3'!$I$5:$J$57 ... and so on depending which sheet name is selected in the dropdown in C2.

I'm trying to reference the above sysntax to the "Chart Data Range" property of the graph but not sure how to (excel 2007).

Thanks in advance,
Paul.

 

[Jon von der Heyden]

I'm not sure about 2007, but in prior versions you would need to use named ranges. I suggest you have a look at how John Peltier uses DNR's for charts here.

 

[LEXCERM]

Jon, sorry for taking so long to get back to you. Your link was very helpful. Thank you very much.

Paul.