Adam Squire has posted a creative way of displaying fourteen different charts in one. It uses one chart object and a data validation dropdown list to change the data in the chart(you’ll need to download the workbook).
If you have ever found yourself with a ridiculous amount of charts in a workbook, this could possibly be a valuable example.

November 19th, 2004 at 9:09 pm
Nice. I’ve used combo boxes from the Forms menu and from the Controls Toolbox to allow a user to select what they want in the chart. I never thought of Data Validation.
Thanks for the link.
November 25th, 2004 at 5:50 am
me to, in a work book i have now there are about 40 charts reformed on the one chart sheet. U think i’m going to stop using the chart sheet, i cant see any advantage in it.