Hi,

For more info on the subject have a look at.
http://www.andypope.info/charts/brokenlines.htm

Cheers
Andy
Marko Pinteric wrote:
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

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info