Logarithmic graph

[John Babcock]

Is there a way to have a logarithmic graph ignore the cells that contain a 0
value or no value in the graphed range??

Thanks ahead of time for the help.

 

[Jerry W. Lewis]

Log(0) is infinite. What do you propose instead?

Logarithmic graphs do ignore cells that contain no value. Do you
perhaps mean that it is not ignoring cells that contain zero length
strings? Try using
=IF(<condition>,<formula>,#N/A)
instead of
=IF(<condition>,<formula>,"")
or
=IF(<condition>,<formula>,0)

Jerry