Hello John,

I've been trying the example you gave me. This time, I managed to
define the name with no problem. So, I defined the Datarange as
=OFFSET(OFFSET(Sheet1!$B$1,Sheet1!$A$1-1,0),0,0,Sheet1!$A$2-Sheet1!$A$1+1)
as you said, and the error which occured the other time following the
example on the webpage no longer happened.

Anyway, if now I select Insert/Name/Define and click on the Datarange
name, the following "Refers" is displayed as on the pcture :
http://www.filelodge.com/files/1043/excelOdd1.jpg

I find a bit odd the =" =OFFSET at the begining ...

But when trying to change the data range using the Datarange i've got
the following error :
http://www.filelodge.com/files/1043/excelOdd2.jpg

Please note that I didn't found the =SERIES( thing on the dialog ...

Strange errors ...

As for the example on tthe webpage link, I tried a few times just
copy-pasting and the error still happens.





John Coleman wrote:
Here is a formula that matches your original problem description:
=OFFSET(OFFSET(Sheet1!$B$1,Sheet1!$A$1-1,0),0,0,Sheet1!$A$2-Sheet1!$A$1+1)
If you name this say "DataRange" then it will refer to the part of
column B between row number stored in A1 and row number stored in A2.
Then if you get the chart series to point to "DataRange" as indicated
on Walkenbach's website - it should work.


Are you sure that you entered the formula in correctly? I just pasted
what you gave into my name dialogue box and had no problem.

Hope that helps

-John Coleman