Hi Mark,

Am Mon, 21 Apr 2014 00:29:40 -0700 (PDT) schrieb Mark Stephens:

I have two named ranges: First Cht3_SRC which is referenced:

=OFFSET(Source3!$B$1,0,0,COUNTA(Source3!$B:$B,1))

try:
=OFFSET(Source3!$B$1,,,COUNTA(Source3!$B:$B))

And Chart3Labels referenced:

=OFFSET(Source3!ChartValues,0,-1)

try:
=OFFSET(Cht3_SRC,,-1)


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional