Using Named Ranges with Charts: Part 2 (!)
 

HELP! Mistifyingme..... Dear All, despite invaluable help... a
persistent error occurs.

My code for one of my named ranges, lets call it Revenues_A is:

=OFFSET(INDIRECT($G$1&"!$Q$4");0;0;1;COUNTA(INDIRE CT(!$G$1&"!
$4:$4")))

I have 22 named ranges in total now, which I plan to use on each of my
50+ Sheets.
Revenue_A is but one of many series of Data for my charts. Cell G1
contains the name of the sheet the Chart is on.

However... Excel persists in putting in the name of the sheet that is
active when I save my Named Range. So Excell turns it into e.g.:
=OFFSET(INDIRECT(Sheet1!$G$1&"!$Q$4");0;0;1;COUNTA (INDIRECT(Sheet1!$G
$1&"!$4:$4")))

Following the links one of you provided I still did not find a
solution. I know I can't solve it by referring to the active sheet,
since my chart will then give an error-message.

PLEASE HELP!

AdP