MicrosoftВ® Office ExcelВ® 2007: Data Analysis and Business Modeling (Bpg -- Other)

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.