Custom format to not display data labels with 0,0 values

[mikelowski]

Hi,

I have a chart with several series and I'd like it to display all data labels except those with 0,0 value. I got some custom format working but then when values are 0,1 or so, it doesn't display the 0 (notice I'm in a region where we use , as a decimal separator instead of dots).

Thanks, fellows

 

[Hui]

Have you tried a Custom Format of 0,00;-0,00;;

If this doesn't work can you please post a sample file

 

[mikelowski]

Hi, Hui

Works perfect! Only thing I used 0,0;-0,0;; since I just want one decimal point. Thanks so much!