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 |
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 |
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 |
"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 |
All times are GMT +1. The time now is 06:22 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com