Range that expand
 

Hi,

I found in one of my Excel book this formula for expanding the range so
I do not need adjust the chart range everytime I add a data.

=OFFSET(Sheet1!$A$1,1,0,COUNTA(Sheet1!$A:$A)-1,1)

The problem I have is tha this formula is good when a row is added.

On one of my charts I have the following:

Week 1 Week 2 Week 3 Etc..
Customer 1 5 3 1
Customer 2 6 0 6
Customer 3 0 3 2
Etc..

Every week I add another collumn. Is there a formula like above that
can help me?

Thank you.

Juran


--
Juran
------------------------------------------------------------------------
Juran's Profile: http://www.excelforum.com/member.php...o&userid=23592
View this thread: http://www.excelforum.com/showthread...hreadid=569250

Range that expand
 

=OFFSET(Sheet1!$A$1,1,0,COUNTA(Sheet1!$A:$A)-1,counta(sheet1!$1:$1))

(not sure if you wanted to subtract 1 from the count of columns, too???)

See Debra Dalgeish's site for some nice tips:
http://contextures.com/xlNames01.html#Dynamic

Juran wrote:

Hi,

I found in one of my Excel book this formula for expanding the range so
I do not need adjust the chart range everytime I add a data.

=OFFSET(Sheet1!$A$1,1,0,COUNTA(Sheet1!$A:$A)-1,1)

The problem I have is tha this formula is good when a row is added.

On one of my charts I have the following:

Week 1 Week 2 Week 3 Etc..
Customer 1 5 3 1
Customer 2 6 0 6
Customer 3 0 3 2
Etc..

Every week I add another collumn. Is there a formula like above that
can help me?

Thank you.

Juran

--
Juran
------------------------------------------------------------------------
Juran's Profile: http://www.excelforum.com/member.php...o&userid=23592
View this thread: http://www.excelforum.com/showthread...hreadid=569250

--

Dave Peterson