From: GENESIS on

I have 8 series that get its value dynamically from other tabs.
Sometimes, all 8 series would have data while other time, only a few.
Question is, how do I hide the legend for those series that returned
back blank value. I understand this may require VBA but I'm not well
versed in it. Any thoughts or if VBA is the only way, can somone post
the code? Thanks.