If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Setting source data range with Charts | D | Charts and Charting | 2 | January 1st, 2006 02:51 AM |
Excel Range Names | trainer2000 | General Discussion | 1 | May 20th, 2005 08:42 PM |
Deleting Range name's listed in the range address box. | Satnam Patel | General Discussion | 4 | May 5th, 2005 01:42 PM |
Charts - Select Year Range | Bill | Setting Up & Running Reports | 2 | November 16th, 2004 09:32 AM |