Clear zeros from a graphic

[Vicente Mateos]

Hello
I have built a graphic with some data that comes from a condition.
When a condition is true I dont want to have any value in the graphic but
the if() condition writes a zero in the cell and the graphic display a zero
instead of nothing.

We have built a macro, but is there another way to do it.

Thank you very much,

Vicente Mateos (Spain)

 

[John Bundy]

What formula are you using? typically its something like
If(test=1,0,"True")
that zero tells what to place in the cell when the test does not = 1
changing the zero to "" will return a blank instead.
Correct me if i misunderstand what you are trying to do.

 

[Andy Pope]

Hi,

Instead of zero use NA()

So if your formula is structure like this,

IF( <test> , <value> , 0 )

change to

IF( <test> , <value> , NA() )

If the chart type is Line the point will not be displayed but the line will
interpolate between points.

Cheers
Andy

 

[Jon Peltier]

The cell isn't blank, it only looks blank. The chart treats the pseudo-blank
the way it treats any text, as a zero. Andy's suggestion to use NA() is the
way to attack this problem.

- Jon

 

[Vicente Mateos]

Thank you very much Jon Peltier, it works...