Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Creating a chart that has a variable data ranges?
I Am hoping that some one can help me with this problem. I am trying to
create a chart in XL 2003 that will automatically update as data is added. the data ranges are variable and may have 10 to 250 entries. For example I may require a data range of A2:A30 and G2:G30 or A2:A220 and G2:G220. I require this chart to update with expanding data tables. Can anyone point me in the right direction. Thanks in advance NAC |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Creating a chart that has a variable data ranges?
See Stephen Bullen's site for a download.
http://www.oaltd.co.uk/Excel/Default.htm FunChrt1 is a workbook showing how to create dynamic ranges for charting. Or browse Tushar Mehta's site for dynamic charts. http://www.tushar-mehta.com/excel/ne...rts/index.html Gord Dibben MS Excel MVP On Mon, 6 Aug 2007 14:44:02 -0700, CattleDr wrote: I Am hoping that some one can help me with this problem. I am trying to create a chart in XL 2003 that will automatically update as data is added. the data ranges are variable and may have 10 to 250 entries. For example I may require a data range of A2:A30 and G2:G30 or A2:A220 and G2:G220. I require this chart to update with expanding data tables. Can anyone point me in the right direction. Thanks in advance NAC |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Creating a chart with varying data value ranges | Excel Discussion (Misc queries) | |||
Need help creating a sum based on variable data. | New Users to Excel | |||
How to set up variable data ranges in nested functions | Excel Worksheet Functions | |||
Selecting Variable Data Ranges | Excel Discussion (Misc queries) | |||
Counting variable ranges and auto-summing variable ranges | Excel Programming |