MrExcel's Learn Excel #993 - Dynamic Charting 1

Tags:: Excel Business Accounting Spreadsheets Tutorials Technology Mrexcel Charting Dynamic Offset

Edit Video Details

Share
Add to Favorites
Report
Download

By: MrExcel
Subscribers: 10
Updated: 25-Nov-09
Videos: 223

International
Comments: 0
Views: 293
Added: 15-Apr-09

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.

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!