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
Bookmarks