Remove Zero Labels from Pivot Pie Chart

[chad_oglesbay]

Hello, first post here but long time observer of this forum; you guys are great! So I have a pivot pie chart that is showing the percentage of error for all the different departments in our organization. As you can see in the image below, with most of the "zeros" up at the top, it looks bad.

So I have searched for a while and found losts of "answers", but none of them worked. Such as, 1) add a filter and uncheck "0"; data filters out but the labels still show. 2) Put a custom format of "0%;;;" on the labels; nope, still there. There were a few other to check or uncheck various boxes but can't remember. Can any of you help? The data for the pivot chart is populated via formulas. It is calculating totals from 10 different spreadsheets and this on is considered the "master". Thanks for any help!

 

[texasalynn]

here is a link for doing that
Pie zeros

 

[chad_oglesbay]

Thank you for the link. I'm trying to apply this but am not able to get this working. Has anyone else done this and can explain a little more than what the spreadsheet lists?