Forum Discussion

crg_42's avatar
crg_42
Copper Contributor
Jan 03, 2025

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 'blank'

 

 

Charting
excel
Formulas and Functions

3 Replies

    • crg_42's avatar
      crg_42
      Copper Contributor
      Jan 04, 2025

      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

       

    • crg_42's avatar
      crg_42
      Copper Contributor
      Jan 04, 2025

      That leaves me with #N/A in the cell rather than blank. But the chart is correct.

Resources