The dynamic formula method is great. I've been playing with this and trying to figure it out on a banking spreadsheet I maintain. The problem is, I've been maintaining the sheet for over 2 years now, so I have a lot of data in it. I don't want to lose the old data, but I don't always want to see the old data in my charts. I was able to create the lists using the offset, but I could never use them in the tables. It turns out the only thing I was doing wrong was entering the names without a sheet reference.

By the way, here are the formulas I used to select the data for the charts:

DateSeries: OFFSET(Sheet1!$A$1,StartDateRowNum-1,0,EndDateRowNum-StartDateRowNum+1)
PaymentSeries: OFFSET(Sheet1!$C$1,StartDateRowNum-1,0,EndDateRowNum-StartDateRowNum+1)
PostedSeries: OFFSET(Sheet1!$D$1,StartDateRowNum-1,0,EndDateRowNum-StartDateRowNum+1)
StartDateRowNum: MATCH(StartDate,OFFSET(Sheet1!$A$1,,,COUNTA(Sheet1!$A:$A)),0)
EndDateRowNum: MATCH(EndDate,OFFSET(Sheet1!$A$1,,,COUNTA(Sheet1!$A:$A)),0)

The StartDate and EndDate are named cells that contain the statement dates for the range.

I always started my offset at the first cell in the row. Then I would define a row number after that to start the data. This proved easier than trying to do an "indirect" and "address" function to try to set the starting point.