Hi,
I have an xy chart that plots Date vs. SVI. The SVI column has a
conditional formula that if the condition is met it will display a value,
otherwise it will display a blank cell.
Even though the cells appear blank they really contain a formula and excel
plots them in the chart as zero values. Is there a way to stop excel from
thinking that the value of the cell is zero? I don't want it to plot this
values. Please help.
Thank you