When I Google this problem, I only see results for the problem opposite to that which I'm having. I need to plot zero values, not get rid of them.

I am plotting logarithmic permeability (x-axis) vs. depth (y-axis). Apparently Excel cannot plot zeros on a log scale simply because the logarithm of zero is undefined (correct?).

Here's my problem. Not only does permeability vary over several orders of magnitude, but it often has a value of zero (or effectively zero). For the project on which I'm working, the depth intervals which have zero permeability are just as important to plot as those that have permeability values greater than zero. Some of the intervals simply have no data, and if I cannot plot the zero-value intervals, then on the graph they are not decipherable from those that don't have data.

If I turn off the Log scale, I can plot zeros, but cannot effectively display the variability of magnitude. Ideas for solutions?

Thanks in advance.