Chart will put 0 data points on graphs for non-zero cells

[rollinn95z]

I am attempting to make a chart with data from column A1-A7 using a
scatter chart. The corresponding Y values in B1-B7 don't always have
data in some cells. For example, if cells B1 & B2 are coded with if
statements like:

=IF(ISNUMBER(B1),$C$22-B1,"")

The "blank" that is returned is forced to zero on the chart. If I have
the conditional statement FALSE out, or TEXT out, the chart still forces
the data point to zero.

Any suggestions??

Regards,

Matt

 

[johnhildreth]

See http://processtrends.com/pg_charts_missing_data.htm

HTH,
John

 

[rollinn95z]

Excellent. That worked great!

Thanks!