Ken.

Make you blanks which I assume are formula generated evaluate as NA()
instead of blank and Excel won't chart them it will interpolate between
adjacent values in the chart.

Mike

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