expanding ranges across columns for graphs

[PAULGOLD]

I have successfully updated charts using the knowledge on "spreadsheetpage.com" which works for data that expands downwards using dynamic range names using eg

A B
date sales
1/4 565
2/4 603
3/4 581

etc
using range names of
sales. ie =offset(sheet1!$B$2,0,0,counta(sheet1!$B:$B)-1)

and for date ie = offset(sheet1!$A$2,0,0,counta(sheet1!$A:$A)-1)

however what i want to do now is define dynamic range names for dates and sales that go accross the columns so that i can very easily update my graphs.
data would be of the kind

A B C D E F
date 1/4 2/4 3/4 4/4 7/4 etc
sales A 10 15 11 15 20
sales B 20 16 25 8 25

how do i formulate the named range names for Date, and for sales A ,and for sales B or should it be one range names for all sales.?
can someone help me please. when i try to invert the formula from eg B:B to 3:3 etc it does not work.
thanks to advise

Regards
Paul

 

[mole999]

at my work they set up a wide table to start with months ahead, and just hide the columns until required

 

[GK039]

Search my posts ("Dynamic Range Fails"). I had a similar problem in the past and the guys in the forum gave me excellent answers. You will find what you ask for there.

George

I have successfully updated charts using the knowledge on "spreadsheetpage.com" which works for data that expands downwards using dynamic range names using eg

A B
date sales
1/4 565
2/4 603
3/4 581

etc
using range names of
sales. ie =offset(sheet1!$B$2,0,0,counta(sheet1!$B:$B)-1)

and for date ie = offset(sheet1!$A$2,0,0,counta(sheet1!$A:$A)-1)

however what i want to do now is define dynamic range names for dates and sales that go accross the columns so that i can very easily update my graphs.
data would be of the kind

A B C D E F
date 1/4 2/4 3/4 4/4 7/4 etc
sales A 10 15 11 15 20
sales B 20 16 25 8 25

how do i formulate the named range names for Date, and for sales A ,and for sales B or should it be one range names for all sales.?
can someone help me please. when i try to invert the formula from eg B:B to 3:3 etc it does not work.
thanks to advise

Regards
Paul

 

[PAULGOLD]

Thanks for your suggestions guys.
however i looked at your posts gk039 but the replies there do not obviously, for me, give me the answer.
I'd appreciate other suggestions.

thanks
Paul