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.
--
Ken