I am plotting a line graph 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 graph inaccurate.
Consider using 


You can setup a graph to handle missing data, but not to handle faultive data. So, to solve this you should protect your timeseries with a code like:
Whereby 

