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


--
rollinn95z
------------------------------------------------------------------------
rollinn95z's Profile: http://www.excelforum.com/member.php...o&userid=33571
View this thread: http://www.excelforum.com/showthread...hreadid=533512

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

HTH,
John

Excellent. That worked great!

Thanks!


--
rollinn95z
------------------------------------------------------------------------
rollinn95z's Profile: http://www.excelforum.com/member.php...o&userid=33571
View this thread: http://www.excelforum.com/showthread...hreadid=533512