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

  • Thread starter Thread starter rollinn95z
  • Start date Start date
R

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
 
Back
Top