Dynamic range for graph
 

Hello,
I am looking for a way to get a dynamic range for a graph
horizontally,

the range starts at A1 and A2
and could go as far as R1 and R2

I have seen lots of info on dynamic ranges for one row or one column
but not 2 rows or 2 columns

Dynamic range for graph
 

Just look in the help index for OFFSET
=offset($a$1,row,column,numrows,numcolumns)

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"damorrison" wrote in message
...
Hello,
I am looking for a way to get a dynamic range for a graph
horizontally,

the range starts at A1 and A2
and could go as far as R1 and R2

I have seen lots of info on dynamic ranges for one row or one column
but not 2 rows or 2 columns