I am plotting a line chart which is a time series. After a certain period of time, the time series shows #NUM! How can I get excel to ignore the #NUM! and plot nothing. Currently, it plots all values of #NUM! as zero which makes my chart inaccurate.