In Episode 994,another solution to Ally's problem of how to make a chart expand whenyou type new data in the worksheet. Today's method shows an easier wayto set up a dynamic chart range in Excel 2003 and newer.

This video is the podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!



More...