2008 US East Coast Excel User Conference September 24-27, 2008
Atlantic City, NJ
Dynamic Chart Links.
Here are a few of the many web links that deal with dynamic charting. This is not intended to be a complete list, nor are the entries in any particular order.
John Walkenbach - The Spreadsheet Page http://j-walk.com/ss/excel/
Dynamic Chart - Demonstrates how to make a chart's data series display data based on the active cell position.
Note for Excel 2007 users: Techniques using named ranges will fail if the names of these ranges begin with the word "Chart". Use names like ChtValues instead of ChartValues.