Hi,

Replace formulas like
=IF(A3<10," ",A3)
with
=IF(A3<10,NA(),A3)

A couple of points:
1. It is probably better technique to use "" to represent a blank cell
rather than " ". In many situations " " would not be treated as a blank
cell, but "" would.
2. In a column or bar chart this technique works very well, however, in a
line chart if your goal was to leave a break in the line, this would not do
it, because as Mike has said Excel interpolates (connects the known points as
thought the missing point was on the line connecting them).
3. You should look at Jon Peltier's website for other useful charting
suggestions:
http://peltiertech.com/Excel/Charts/
--
Thanks,
Shane Devenshire


"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