Dynamic range for graph

D

damorrison

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
 
D

Don Guillett

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

syntax to concatenate two named ranges? 2
Need Help with a VBA subroutine 0
Dynamic graph issue 2
hLookup dynamic range 2
Dsum and Dmax with structured references 1
Saving a range for later reference 0
Dynamic data ranges in pivot tables 3
Select range then copy rows macro 1

Top