How to replace zero values with blank?

[#1]

Hi,

Does anybody know how to replace the zero values with blank wehn setting up a chart object?

Any help will be very much appreciated. Thanks in advance!

[#2]

hi,

you can uncheck "suppress zero values" in chart properties 'presentation' tab to display null values.

and use

set nulldisplay=' ';

to represent your null values.

thanks

[#3]

HI

Could you possibly explain where in the script this should go?

Cheers

[kji]

You dont have to do anything in the script, use a dual function for your expression in the chart:

Dual( if(exp=0,' ', exp),exp)