Hiding and unhiding a chart based on data

[Elqueso]

Hello,
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o> </o>
I’m trying to hide a pie chart based on data that is selected by a drop down menu.
<o> </o>
I currently have a chart with Customer and Sales data. This is the primary way for me to display information, and I have a dropdown menu to select different customers which alters this chart. The problem I’m having is that for some customers there is additional data. i.e. retail vs commercial. I have displayed this breakdown with a secondary chart (pie chart), but not all customers have this breakdown. I’ve inserted “IF” formulas to hide/unhide the data, but I would like to know if there is a way to hide/unhide the secondary chart.
<o> </o>
I read that we are not allowed to post email addresses, but if someone wants to send me a PM, I will gladly send the spreadsheet.
<o> </o>
Any help would be appreciated.
<o> </o>
<o>thanks </o>
<o></o>
I'm currently using Excel 2003 in Windows XP<o></o>

 

[pbornemeier]

This code will hide the first chart on the active worksheet:
ActiveSheet.ChartObjects(1).Visible = xlHidden

This code will make it visible;
ActiveSheet.ChartObjects(1).Visible = xlVisible