Ed has the right idea about using the OFFSET and COUNTA functions to
create dynamic ranges for charting. However, AFAIK, there is no way to
use a range that contains multiple columns *and* multiple rows in a
chart. It has to be as single column (or row).

For more see
Dynamic Charts
http://www.tushar-mehta.com/excel/ne...rts/index.html

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article ,
says...

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