Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Range Names with Charts
I would like to use rangenames to specify the data sources for a chart, but
Excel does not seem to like this. I have tried entering the rangename in the following formats: rangename =rangename ={rangename] ={"rangename"} .... and various other formats. Surely there is a way to do this ....? Art |
#2
|
|||
|
|||
Hi,
try either depending on whether the named range is local to the sheet. =sheetname!rangename =bookname.xls!rangename cheers Andy ArthurJ wrote: I would like to use rangenames to specify the data sources for a chart, but Excel does not seem to like this. I have tried entering the rangename in the following formats: rangename =rangename ={rangename] ={"rangename"} ... and various other formats. Surely there is a way to do this ....? Art -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
#3
|
|||
|
|||
you need to add the file name
for example if you are in source data-series and you want a named range (xy) in Workbook named test.xls enter the values as =test.xls!xy "ArthurJ" wrote: I would like to use rangenames to specify the data sources for a chart, but Excel does not seem to like this. I have tried entering the rangename in the following formats: rangename =rangename ={rangename] ={"rangename"} ... and various other formats. Surely there is a way to do this ....? Art |
#4
|
|||
|
|||
"bj" wrote: you need to add the file name for example if you are in source data-series and you want a named range (xy) in Workbook named test.xls enter the values as =test.xls!xy "ArthurJ" wrote: I would like to use rangenames to specify the data sources for a chart, but Excel does not seem to like this. I have tried entering the rangename in the following formats: rangename =rangename ={rangename] ={"rangename"} ... and various other formats. Surely there is a way to do this ....? Art |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Range Names | Excel Discussion (Misc queries) | |||
Deleting Range name's listed in the range address box. | Excel Discussion (Misc queries) | |||
range names | Excel Worksheet Functions | |||
range names | Excel Worksheet Functions | |||
range names | Excel Worksheet Functions |