Graphing help

[Daniel Thomas]

How do I ignor blank formulas in a graph

I am trying to graph a range of formulas that either return a value or "". I dont want the graph to show "" as 0's, I dont want them to show up at all. I just want the return values to show up on the graph, and the rest to react like a blank cell.

 

[SydneyGeek]

If you set the blanks/zeros to display #N/A or just N/A, they won't plot in an Excel chart

Denis