Data Label formatting in Chart

[Ecel Dumbo]

Hi, I have applied a format to my data label $#, K which shows the values like $90 K, $20 K
However I have few blanks/or zeros appearing in the data series. For those data, it appears as $ K on my graph, i would like to see it as blank on the graph but stick to the $90 K format for whereever there is data. Please help

 

[Hui]

What about something like a formatting code of:
[<500]$ 0;[>=500]$ #, K;0

Have a read of:
http://chandoo.org/wp/2011/08/19/selective-chart-axis-formating/
http://chandoo.org/wp/2011/08/22/custom-chart-axis-formating-part-2/

 

[Ecel Dumbo]

Thanks HUi