Custom Number Format on Data Labels

[Siyanna]

Hi All

i have created a pivot bar chart

some of the data has 0 or N/A

how can i add a custom format the show blank in the data label if it is 0 or N/A?

thank you

 

[RoryA]

Custom number formats won’t suppress an error value.

 

[Siyanna]

Whats the best way to get around this matey?

 

[RoryA]

In the pivot table options, check the 'For error values show' option and leave the box blank (or use 0) then use a custom number format like
0;-0;;
to hide the 0 values.

 

[Siyanna]

Thank you