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())
That leaves me with #N/A in the cell rather than blank. But the chart is correct.