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

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?

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/softwa...ity/index.html
http://www.andypope.info/charts/brokenlines.htm

Cheers
Andy

Tania wrote:
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, Microsoft MVP - Excel
http://www.andypope.info