How do I force a line chart to not plot cells that are "null".

[Tania]

These cells are not empty, as they have an IF statement in them to force a
"null", so the setting in Options, to not plot empty cells, is not working.
Any ideas?

 

[Andy Pope]

Hi,

When the cell is not truly empty then something is plotted.
See here for the various combinations of cell content and line
appearance and possible work arounds.

http://tushar-mehta.com/excel/software/na_discontinuity/index.html
http://www.andypope.info/charts/brokenlines.htm

Cheers
Andy