Logarithmic graph

  • Thread starter Thread starter John Babcock
  • Start date Start date
J

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.
 
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
 
Back
Top