Hide pie charts if chart is blank/empty?

[mrbusto71]

Hey folks!

I just spent the better part of an hour searching for how to do this and haven't been able to figure out the limited VBA examples that're out there to fit my needs. Turning to the forum in hopes of getting some help/suggestions.

What I want to do is pretty straight forward:

I have 9 pie charts on a sheet. Sometimes all 9 will have data to show, sometimes only 2 charts will have data to show, or 5 charts, etc.

I simply want to put some VBA code together that'll cycle through the charts, and if there are no data points to show (i.e. all blanks or all 0), I'd like to just hide the chart since it's not displaying anything of use.

My charts used named ranges for the data source, but otherwise it's all pretty plain jane.

Don't necessarily need someone to write code for me (unless you're feeling it, in which case I won't stop you :P), but would just love a gentle shove in the right direction so I can figure this out and move on with my project.

Any help is greatly appreciated!

[Andy Pope]

I think the issue is knowing when the pie is truly empty. If it is just the cells content that is changing then the series points count will remain the same.

You would need to check the Values property of the series.

Please Login or Register  to view this content.

This would still display the chart even if all the values where zero. You would need to make the call on whether zero is a valid data point.
If yes, then you would need to modify the code to check length and actual values