Hide Legend With No Data in Series

[GENESIS]

Folks,

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.

 

[Jay Walker]

Hi. I have the exact same question. Did you ever figure out how to accomplish this?

Thanks.

 

[GS]

Jay Walker explained :

Hi. I have the exact same question. Did you ever figure out how to
accomplish this?

Thanks.

Have you tried using Autofilter with '(non blanks)' as the criteria?

 

[msaninfo]

You hide the rows to remove the series in the charts. Default option in chartdisplay data only visible cells.