Auto-Hide Data label if data is 0% - Percentage

[dLhx]

Hello everyone,

I have a chart in which i would only like to show values that are different than 0%. I know that for numbers you need to format the cells from which the chart is taking the data (0;; but for percentages is there a different way?

Cheers,
-Alex

[berlan]

Maybe,

[<>0]0%;


or

0%;-0%;;General

(numberformatting)

[dLhx]

I tried that but the values still appear in the chart. I have to manually delete them.

[berlan]

Untested from my side, but should work when it comes to x and y axis numberformatting. for the actual values not to show up in a chart series, may need to delete it or trigger na()

[Glenn Kennedy]

Triggering #N/A is probably better...

[dLhx]

Tried triggering #N/A, still not working, so i am back to deleting the numbers manually

[Glenn Kennedy]

Can you post your sheet?

[dLhx]

Sorry but i cannot. It is a document from my work and it contains sensitive materials

[Glenn Kennedy]

Can you not mock up something similar showing your problem???