I have set up a dynamic chart using the Defined Name
=OFFSET(Template!$C$#,,,COUNTA(Template!$C$3:$C$20 000),1) Named datalabel,
and Defined Name =OFFSET(datalabel,0,1) Named data. These named ranges where
saved in chart1.xls and worked fine. However, When I re-created the same
Defined Names in chart 2.xlt and tried use them in a chart, a message
returned Referrence not valid, Work book must be open? chart2.xlt was open?