Hi,

All non numeric values in cells will be treated as text and therefore
charted as zero.
The exception is the use of the formula NA() which will suppress the
plotting of a data marker. In a line chart the line will be joined
between 2 valid data points.
The only way to get a line break is to have truly empty cells.

Cheers
Andy

Ken wrote:
I'm creating a chart from a column of numerical values. Several of the cells
in the column are blank (=" " rather than having them display an unstable
value which they would be otherwise). When this set of data is transferred to
an Excel chart the cells with the " " value are charted as if the cells have
the value of zero. How do I exclued these entries from being included in the
charts without affecting the desired data? I would like the blank values to
show an empty spot in the chart rather than a value of zero.

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info