If 0, don't display point on graph

Hi, I have the following formula
=IF(ISBLANK(D10),"",M10-F1*(D10-C10)/C10)
Which displays a point on the graph as 0 if the cell D10 is zero, ideally I would like the line graph to stop at that point instead of heading for the axis.

At the moment the only work around is to make the cell equal to the previous one in the "value if true" argument, so it forms a horizontal line - which is far from imperfect!

Cheers,
CB

My apologies, I have found the solution seconds after posting here - having spent about an hour looking for it! Typical, Never mind!

Anyway, for anyone else who is interested, I solved it like this:
=IF(D10=0,NA(),M10-F1*(D10-C10)/C10)

NB. my D10 cell is taking a value from another worksheet so is print out a 0 rather than a blank at this stage.

Cheers,
CB