Removing "null" data from a graph

  • Thread starter Thread starter JanetW
  • Start date Start date
J

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!
 
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 :-)
----------------------------------------------------------------------------



Peo Sjoblom said:
Try

= IF(condition,ValueIfTrue,NA())
Click to expand...
 
Sweet! Thanks! I was looking all over the help for some sort of "null()
function to no avail
 
Back
Top