The Table feature in Excel 2007 makes it easy to set things up so that charts and formulas automatically incorporate new data. See Chapter 24, “Tables,” for a discussion of this new feature.