Learn Excel Episode 993: Dynamic Charting 1

Posted in Companies, Podcasts on April 17, 2009



Ally asks how to have a chart automatically extend as you type new data. The classic solution is to use a pair of dynamic named ranges using OFFSET. While this can be painful, Episode 993 shows how to set it up. Be sure to watch Episode 994 tomorrow for an easier way in Excel 2003-2007.

Watch Video Watch Video on External Site

Tags: Microsoft, Excel, MrExcel, Broadcasting, Screencasts, Companies