Excel 2007 : Show Last 25 values in Chart

I've got a chart with some dollar values that are all listed in Column I and get updated each time I add an entry to the sheet.

What I'd like to do is have my chart dynamically adjust to show only the last 25 values I've entered.

I've attempted this with the offset formula but I'm quite a bit confused by it and didn't have any luck.

Column I
 $145.00 
 $140.00 
 $144.55 
 $153.64 
 $143.64 
 $148.19  < Show from this value down to the bottom of the list.
 $138.19  < When new value is added, show from this value to the bottom of the list.
 $128.19 
 $137.71 
 $127.71 
 $145.00 
 $140.00 
 $144.55 
 $153.64 
 $143.64 
 $148.19 
 $138.19 
 $128.19 
 $137.71 
 $127.71 
 $145.00 
 $140.00 
 $144.55 
 $153.64 
 $143.64 
 $148.19 
 $138.19 
 $128.19 
 $137.71 
 $127.71

Thanks