What do the series formulas look like in XL2000 and XL2007? There is a
problem with XL2007 in that sometimes the names in a series formula are
converted from Book1.xls!MyName to [0]!MyName. This is fixed in SP1.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"hmm" wrote in message
...
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.