I am working with a line chart and do not want it to plot #N/A s. I tried the following formula but it is still plotting the cell.

=IF(ISNA(cell number),NA(),cell number)

With this formula the chart no longer plots the cell as a 0 but it connects the previous and following cell info. I do not want it to plot this cell at all. I would like it to leave a gap.

Can anyone help?

thanks