Problem with using named ranges to create charts

A

arminasas =]

In excel 2003 to Define Name I write

Names in workbook: Values
Refers to: =Sheet1!$B$7:$C$7-Sheet1!$B$3:$C$3

and to SERIES formula I write

=SERIES(;;Book1!Values;1)

It works perfect in excel 2003.
But why it doesn't work in excel 2007?

Thanks
 
Top