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