I am pulling my hair out over this stupid thing. I am using MS Excel 2003
I have a column of data that I am trying to graph the problem is the column
derives its data from a formula in the cell if the formula is true than the
cell has a visible data value in it if it is false the cell has no visible
data value just the formula value that shows as a blank cell except for in
the formula window. My problem is that My plot for my chart is from Cells A1
to A50 which all have formulas but only A1 to A20 actualy has visible value
in the spread sheet because the rest of the cells have a formual boolean
value of false and only display a visible value in the cell when the formula
is true. Now when I plot A1 to A50 I still get the line plot on the graph
dropping to a zero value after cell A20 even though the cells in the spread
sheet have no visible values. Oh and I already went into chart settings and
set it to "Do Not Plot Empty Cells" Technicaly the cells I am ploting are not
empty they contain formulas but visibly they are empty untill that formula =
a true value.

Can someone tell me how to plot cells with formulas that don't have a
visible value in that cell on the spread sheet as "NOT Ploted"

Thanks
Dan Thompson