Removing "null" data from a graph

[JanetW]

If I have an IF formula in a cell that evaluates to a blank when false:

= IF(condition,ValueIfTrue,"")

And then use this in a line graph, Excel graphs it with a value of
zero, even if the chart option is set to "Plot empty cells as: Not
Plotted (leave gaps)". Apparently, the presence of a formula violates
the empty cell criteria. Is there anyway to get a formula to evaluate
in a way that the graph won't plot any point at all?

Thanks!

 

[Peo Sjoblom]

Try

= IF(condition,ValueIfTrue,NA())

 

[Ken Wright]

Only thing that won't do on a line graph is give you a blank space if the NA()
is in the middle of a set of data. It will prevent a line from appearing if the
NAs are at the end of the data, but in the middle it will simply join them up.
With a bar or column graph, the bar or column will not appear wherever the NA is
regardless.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 00/02/03

----------------------------------------------------------------------------
Seasons Greetings and Very Best wishes to all
----------------------------------------------------------------------------

Try

= IF(condition,ValueIfTrue,NA())

 

[JanetW]

Sweet! Thanks! I was looking all over the help for some sort of "null()
function to no avail

 

[Jon Peltier]

Janet -

We've been looking all over for it too, but still can't find it.

- Jon