As you can see in the attached image, pie chart in Excel 2016 where I need to show the category name and values in the chart. The data typically have some zero values in it that I do not want to show on the chart. I can hide the zero by using custom number format 0;"" but it still leaves the category name and the visible which makes the chart messy to read. Is there any way to accomplish this?
Unfortunately there is no straight forward approach to this scenario.
Please go through this link and pick out a suggestions that suits to your scenario.
https://www.techrepublic.com/article/how-to-suppress-0-values-in-an-excel-chart/