Ignoring zero values on graph

Originally Posted by Andy Pope

There is nothing else that a chart would understand.
Numbers as Numbers
Text as Zero
N/A as marker surpress

If I may, I would like to add:
Empty cell as discontinuity (i.e., no marker and no line, for line graphs). (This is a true empty cell; a cell with blank text is treated as zero.)