Clear zeros from a graphic
 

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)

Clear zeros from a graphic
 

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.
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"Vicente Mateos" wrote:


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)

Clear zeros from a graphic
 

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

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Vicente Mateos" <Vicente wrote in message
...

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)

Clear zeros from a graphic
 

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
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"John Bundy" (remove) wrote in message
...
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.
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"Vicente Mateos" wrote:


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)

Clear zeros from a graphic
 

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





"Vicente Mateos" wrote:


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)