Named Range Graph Data
I am importing data on a monthly basis from an access query that varies in
size into an Excel spreadsheet. The named range the data is being imported into is not adjusting to accommodate the new data, whether it be more data or less. For example, if the range of data is A1 to C90 one month, but the next month the range is A1 to C275, the named range is not adjusting itself to the furthest portion of the new range (C275). Is there a setting I'm missing? I assumed the range would adjust according to the data being imported into it. Thank you in advance. |
Named Range Graph Data
The named range adjusts according to the way its Refers To formula is
constructed. Make sure there is some kind of COUNT/COUNTA inside the Refers To definition. For example: http://peltiertech.com/Excel/Charts/...umnChart1.html http://peltiertech.com/Excel/Charts/Dynamics.html Even easier, establish the data region as an Excel List (Data Menu List). As data is added or removed, the list automatically resizes, and any formulas linked to the address of the list automatically adjust to the new address of the list. Pretty cool feature, my whole reason to upgrade from Excel 2000 to 2003. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Me" wrote in message ... I am importing data on a monthly basis from an access query that varies in size into an Excel spreadsheet. The named range the data is being imported into is not adjusting to accommodate the new data, whether it be more data or less. For example, if the range of data is A1 to C90 one month, but the next month the range is A1 to C275, the named range is not adjusting itself to the furthest portion of the new range (C275). Is there a setting I'm missing? I assumed the range would adjust according to the data being imported into it. Thank you in advance. |
All times are GMT +1. The time now is 08:26 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com