Named data series won't dispay in Excel 2007

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

hmm - 20 Jan 2008 12:38 GMT

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.

Reply to this Message

ShaneDevenshire - 21 Jan 2008 16:14 GMT

Hi,

I have created a 2000 Excel chart using dynamic range names and then opened
it in 2007 - there were no obvious problems. The dynamic ranges continue to
work.

One thing to keep in mind names some names which would have worked in 2000
will not work correctly in 2007 because they may be cell address or other
conflict.

Signature

Cheers,
Shane Devenshire

> 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.
[quoted text clipped - 11 lines]
> 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.

Reply to this Message

hmm - 21 Jan 2008 16:29 GMT

Thanks Shane.

I checked the name syntax rules for Excel 2007, at:
http://office.microsoft.com/en-us/excel/HA101471201033.aspx#Syntax%20rules%20for
%20names

They appear to be the same as for E-2000. Are there any undocumented rules
you know of?

> Hi,
>
[quoted text clipped - 21 lines]
> > 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.

Reply to this Message

ShaneDevenshire - 21 Jan 2008 16:58 GMT

I don't know if there is documentation in Help but try this in 2007

Define the name ABC1

That would work in 2000 but not in 2007 because that is now a cell address.

Same for A100000.

Signature

Cheers,
Shane Devenshire

> Thanks Shane.
>
[quoted text clipped - 29 lines]
> > > 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.

Reply to this Message

Jon Peltier - 21 Jan 2008 17:54 GMT

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
_______

>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.
[quoted text clipped - 14 lines]
> 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.

Reply to this Message