I have stock data in excel which I'd like to chart using
the high low close option. Problem is that the data
contains zeros on some days. Can I get excel to ignore
the zeros instead of plotting them. If not what's the
best way of converting these zeros to  blank cells so
that Excel does not chart them.
Thank you