I have 40 pie chart categories, 6 currently have data. This is a living document and I'd like the categories that have no data be removed from the pie chart. It's a hot mess.

I've tried:
0%;;;
0%;-0%;;;
#,#00;;;
Changing my chart to return "N/A" or nothing for zero values


All of these only hide the 0% and not the category labels.