I'm trying to create chart using dynamic named ranges. My coding returns an error on the Bolded line:
Run-Time error '1004': Application-defined or object-defined error
My named ranges are:
Bat_Perc scope: Raw Data =OFFSET('Raw Data'!$B$2,0,0,COUNTA('Raw Data'!$B:$B),1)
Date_Time scope: Raw Data =OFFSET('Raw Data'!$A$2,0,0,COUNTA('Raw Data'!$A:$A),1)
It seems Excel does like my named ranges. Could the scope setting maybe need to be changed to Workbook?
I'd appreciate any help anyone has to offer. Steve
HTML Code:
Bookmarks