Excluding zeros

[Ben]

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

 

[Bernard V Liengme]

Hi Ben,
Two ways:
1) replace zeros (or missing data) by =NA()
2) Tools/Options/Chart and specify what is to be done with missing values.
Bernard