Hi all,

I have set up a named range as such: (name = "blah1")
=OFFSET('F_5050 FP'!D1223,'F_5050 FP'!$B$2-1,0,'F_5050 FP'!$H$1,1)

And it works, it selects the right range of values (a column of numbers).

Then I create a new line chart, edit series, set series values to:
='F_5050 FP'!blah1

(which is a range, right, so should work?)

And I just get "a formula in this worksheet contains one or more invalid references"

Thanks in advance