Graph line falls to zero

**jngil** · 03-06-2009, 05:36 PM

Hello.

I have a graph (type line) corresponding to a list of values in a range of cells: B1; B2; B3

The values of these cells are calculated based on the values of other cells: X1; X2; X3
Values: 40; 45; "empty" (no value)

Thus, the value of cell "B3" is equal to ... nothing, nothing visible but the cell has the function "= X3"

Now the problem:

I create a chart (type line) and the curve goes up to cell "B2", in cell "B3" the curve falls to zero.
I would like the end of the graph line in cell "B2" and do not fall to zero because, in fact, the value of cell "B3" is not zero ... is nothing (empty), but Excel interprets the cell (with a function resulting in empty cell) as if it was zero ...

Please, is there a solution for this?

Thanks a lot,
Gil

jngilx@gmail.com

**shg** · 03-06-2009, 06:05 PM

If the formula in B3 is =X3, and X3 is blank, then B3 contains the number zero, not 'nothing.' You may have suppressed display of zeros, but it's still there as far as Excel is concerned.

You could change the formula to =if(x3<>"", X3, na())

**jngil** · 03-08-2009, 01:08 PM

Thanks for your reply. Helped much.
The problem of the graph is solved!

However, and I'm sorry to bother you again, the list of values is not ... "beautiful" with "#N/A" in the cells.
Is there any way to hide this information (I tried "Conditional Formatting" but without success)

Thank you,
Gil