Marko:

In your If statement, replace "" with Na(). Excel will place a #N/A in the
cells that were getting the "". Excel charting recognizes #N/A and will not
go to 0.


See this post for more details.
http://processtrends.com/pg_charts_missing_data.htm

...Kelly



"Marko Pinteric" wrote in message
...

I have a range of IF formulas. Sometime IF returns number, sometimes "".
The problem is that chart displays "" as value 0. Is there a way
to force chart not to display those empty values?

IF(condition; number_value; "")

Marko