Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Changing graph axes using named range | Charts and Charting in Excel | |||
get data from a cell in each named range | Excel Worksheet Functions | |||
Blank cells in named range- how to ignore them when making my graph? Help plz! | Excel Discussion (Misc queries) | |||
Can I use named range in data range box when creating pie chart? | Charts and Charting in Excel | |||
Named dynamic ranges, copied worksheets and graph source data | Charts and Charting in Excel |