Chart

[SS]

Hi

I want to plot a chart but it not to show the values if the value of the
formula is zero even though they are ranged.

Is there anyway this can be done?

Cheers
Shona

 

[Andy Pope]

Hi Shona,

Try using the NA() formula instead of zero or ""

Cheers
Andy