A file created with Excel 2000 contains a chart with a dynamic, named data
series. I emailed the workbook file to a colleague who uses Excel 2007.
When he opens the file, the data series simply doesn't display. When I
examine (in E-2007) the chart's source data, Excel tells me there is an error
in a formula. The three formulas are the names Header, xData, and yData
(preceded, of course, by the filename and "!"). When I enter one of these
names in the name box, it is recognized, as indicated by selection of its
cells. I was only able to get the chart to display the series by replacing
the x- and y-data names (xData and yData) with literal range references
(e.g., A1:A2000 and B1:B2000. Interestingly, the name "Header", referring to
a cell containing the chart series name, is resolved and displayed by the
chart.)

Can anyone tell me why named ranges for x- and y-data in charts are not
transferring from Excel 2000 to 2007, and how I can fix it? Thanks.