help with hiding and unhiding a chart based on data

Hello,

I’m trying to hide a pie chart based on data that is selected by a drop down menu.


When I use the drop down menu (yellow highlight) some of the values change on the first chart. Customer "A" has both retail and commercial sales (see J2:K3 in yellow) that I need to show on a seconday chart (pie). The other customers do not. Is there a way to hide/unhide the pie chart based on the drop down selection? I don't want to see a pie chart for customers "B" and "C". Only for customer "A"

just another FYI, the drop down menu is linked to cell c2 also in yellow. And I'm currently using Excel 2003 in Windows XP

Any help would be appreciated.

Thanks