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
[email protected]
Bookmarks