IF statement not returning a blank so a chart line won't gap

  • Thread starter Thread starter mikekaf
  • Start date Start date
M

mikekaf

I have an IF formula that should return a blank to a cell using the "". but
the chart does not recognize it as a blank and drops the shart line to zero
instead of showing a gap
 
I have an IF formula that should return a blank to a cell using the "". but
the chart does not recognize it as a blank and drops the shart line to zero
instead of showing a gap
Click to expand...

The chart interprets "" as 0 so if you replace the "" with NA() in your
IF formula your chart will show the gap correctly.
 
The chart will not show a gap. It will omit a marker at this X value, but if
the markers are connected with lines, the line will connect the points on
either side of the missing marker.

- Jon
 
Back
Top