CODEWITHSUNDEEP
excelexcel-charts
AV114
AV114

Reputation: 41

Hide Category Name From bar Chart If Value Is Zero

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?

enter image description here

Upvotes: 0

Views: 3215

Answers (2)

user20419629
user20419629

Reputation: 1

The only hack I found is to add an IF formula into the cells containing the category names...

Upvotes: 0

R_K
R_K

Reputation: 28

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/

Upvotes: 0

Related Questions