Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Variable data range help
I'm looking to build a variable data range to help in some charting. I've tried a few forumla/text combos and have had no luck thus far. I'm wondering what is exceptable to use in the data range feild. Is the string I've tried. Basically I'm looking to create an open ended data range. Any help?? ='Chart Info'!$H$40:$I$"&COUNT(I:I)+39&",'Chart Info'!$M$40:$N$"&COUNT(I:I)+39 Thanks! Ryan -- low98 ------------------------------------------------------------------------ low98's Profile: http://www.excelforum.com/member.php...o&userid=30316 View this thread: http://www.excelforum.com/showthread...hreadid=499794 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data Validation range | Excel Discussion (Misc queries) | |||
Dynamic Data Range | Excel Worksheet Functions | |||
How to create a chart based on a 2 dim data range dynamical in 1 d | Charts and Charting in Excel | |||
Inserting Filtered RC cell information into other worksheets | Excel Discussion (Misc queries) | |||
Extending a Chart Data Series from an Array - Can it be done? | Charts and Charting in Excel |