IF statement not returning a blank so a chart line won't 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

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

Replace the "" in your formula by NA()
--
David Biddulph

"mikekaf" wrote in message
...
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

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

On Wed, 2 Jan 2008 12:19:01 -0800, mikekaf
wrote:

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

The chart interprets "" as 0 so if you replace the "" with NA() in your
IF formula your chart will show the gap correctly.
--

Cheers . . . JC

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

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
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"JC" wrote in message
...
On Wed, 2 Jan 2008 12:19:01 -0800, mikekaf
wrote:

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

The chart interprets "" as 0 so if you replace the "" with NA() in your
IF formula your chart will show the gap correctly.
--

Cheers . . . JC