Kelly O'Day wrote:
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
That works, but only partially.
I have such case
<number1
<number2
<number3
#N/A
#N/A
#N/A
<number4
<number5
and then <number3 and <number4 get connected. I want that space
between <number3 and <number4 is empty.
Marko