Excluding zeros

  • Thread starter Thread starter Ben
  • Start date Start date
B

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
 
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
 
Back
Top