Solved: Offset Function

[IgnBan]

Need some help generating some named ranges with the OFFSET function. I have a data table that needs to define names. I need to define the OFFSET ranges A4:A500, B4:B500, C4:C500, D, and E. What I need is to make a dynamic chart and use these defined ranges names to make the chart dynamic.
I attached a sample work book.
Any input is in advance appreciated

[Bob Phillips]

This is what you need for column A name

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

adjust the others to suit.

[IgnBan]

Thanks Xld, works very well.