Hi,

A B
X N
X Y
X Y
X Y
"" ""
"" ""
...

thanks for the link... i tried that but i can't enter the formula for the values:

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

because i have alot of "" which i do not want included. i tried using:

=sheet1!B1:INDEX(sheet1!B1:B100,MATCH(2,1/(sheet1!B1:B100<>"")))

but although the name was defined, the chart was incorrect when the series formula was entered.

any ideas?