Forum Discussion
Problem with chart
In my date I have cells with the formula =IF(C5>0,B4,"") In the accompanying graph, cells equating to "" are shown as zero . which I do not want How can I get the points on the graph to equal 'bl...
Try
=IF(C5>0,B4,NA())
Thanks but that leaves #N/A in the cells.
So I have added conditional formatting = error with a white text and that achieves what I wanted
Thanks again