Remove legend if value is N/A

[defy]

Hi all!
Here to scoop up some of your help again =) =P

I have a bar chart and a lot of it is blank because a lot of the values i have are n/a (so zero wont show) is there a way to prevent the cart d\from displaying data if it is n/a or 0? maybe a macro of some sort?

Cheers yall!

 

[DonkeyOte]

x-posted (as yet unresolved): http://www.excelforum.com/excel-general/758393-remove-legend-if-value-is-n-a.html