P
Pringles.
is there a formula i can use to have a chart not have a line until a new
point is determined? i have a column of with the formula =IF(B6>B5,B6,NA()".
my problem is, when it skips a value (that is, when the value is not plotted
because of the "NA()"), i want it to not show a line until they next value is
shown. i just want gaps where the NA's are.
any way to do this?
thanks much,
stephen
point is determined? i have a column of with the formula =IF(B6>B5,B6,NA()".
my problem is, when it skips a value (that is, when the value is not plotted
because of the "NA()"), i want it to not show a line until they next value is
shown. i just want gaps where the NA's are.
any way to do this?
thanks much,
stephen