Supress Chart If No Data

[higleyjp]

I'm trying to use Conditional Formatting on a pie chart so that if there is no data (i.e. all of the values are zero) the chart will be suppressed. Unfortunately no matter what I do with the fill or text color it still shows up with 33.33% assigned to each slice. Help!

Thanks!

Justin

[comment]

There is practically nothing in a chart that can be conditionally formatted. However, you can make your labels a calculation - if there are no labels, no pie is drawn.

[higleyjp]

Thanks! That's exactly what I needed.