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

T

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Non Linear Scatter plot, need to find y value 3
how can an empty cell equate to non-plot point rather than zero? 2
XY Charts - not plotting zero or #N/A Points 2
How do I plot "" as empty rather than zero in a chart 2
plots sent to to a chart tab do not show plot & I loss the plot 0
How do I stop chart from plotting null values as zeros in excel 20 3
Excel line chart not displaying correctly 1
Excel 2007: Line where a gap should be, but only when plotting on ahorizontal date axis 2

Top