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.
=IFERROR(A1,NA()). This will replace all error values with
NA(), which Excel will automatically skip giving you a gap.
You can setup a graph to handle missing data, but not to handle faultive data.
So, to solve this you should protect your time-series with a code like:
A1 would be your "raw" data and
B1 is the cell/column which you will have to use as chart-input.