| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Using Range Names in Charts
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 -- Eli Kedar Israel |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Using Range Names in Charts
If the name begins with "chart", you may have trouble implementing it.
- Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Eli Kedar" wrote in message ... 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 -- Eli Kedar Israel |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Using Range Names in Charts
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 -- Thanks, Shane Devenshire "Eli Kedar" wrote: 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 -- Eli Kedar Israel |
|
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Using Range Names in Charts
Thanks Shane, that was my problem
Eli -- Eli Kedar Israel "ShaneDevenshire" wrote: 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 -- Thanks, Shane Devenshire "Eli Kedar" wrote: 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 -- Eli Kedar Israel |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| COPYING FORMULA CONTAINING NAMES/RELATIVE RANGE NAMES | Excel Discussion (Misc queries) | |||
| Range Names in Excel Charts | Charts and Charting in Excel | |||
| Selecting range in list of range names depending on a cell informa | Excel Discussion (Misc queries) | |||
| Assign charts names in VBA? | Excel Discussion (Misc queries) | |||
| Range Names with Charts | Charts and Charting in Excel | |||
Hybrid Mode
