I would like to set up a variable range that I can use in a chart.

I am tracking five columns of data that I add to every day. I would like to
track the most recent three weeks in a chart.

I am thinking that this should be do-able using some variation of the offset
function and the Max function but I am not really sure how to set it up any
ideas would be appreciated

=OFFSET(Sheet1!$A$3,0,0,COUNTA(Sheet1!$A$2:$A$550) ,1)





--
Jeff