Using Range Names in Charts

[Eli Kedar]

I just converted from Excel 2003 to 2007.
Whwn I try to use Range Names in charts I get an error "Formula contains
invalid references"
Please Help

 

[Jon Peltier]

If the name begins with "chart", you may have trouble implementing it.

- Jon

 

[ShaneDevenshire]

Hi,

Jon has given you one reason, here is another

If the chart is bound to a table (list) range:

"you may receive the following error message:
A formula in this worksheet contains one or more invalid references. Verify
that your formulas contain a valid path, workbook, range name, and cell
reference."

See the following for the complete explanation, but no solution:
http://support.microsoft.com/kb/931389/en-us

 

[Eli Kedar]

Thanks Shane, that was my problem

Eli