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
Bookmarks