leopaulc,

I believe the practical solution here is to create range names of the data subsets that are strategic to your business, then auto create charts using a drop down list of these same range names. The vba code would be fairly simple. So you would select 3rdQ11Profits on the drop down list and the macros would be tied to the dropdown and instantly create the chart, say, to the right of the drop-down. Then select 1stQInv12 and the old chart disappears and the new one is constructed showing the inventory levels. Once you moved the chart from its position it would be immune to deletion and you could build a sheet of charts important for a particular meeting.
The non vba solution is very cerebral and involves creating a specialized set of range names.