0 on a logarithmic axis

[Guest]

I have a chart I am trying to plot data from 0ng to 1.9mg and a logarithmic
scale works beautifully except that I have an important value at a 0ng (the
start of my curve). Is there anyway to make the 0 value show up in a
logarithmic scale?

Thanks,
-E

 

[David Biddulph]

No. Zero on a log scale would be at minus infinity. You could change the
value from zero to something very small (10^-n g), but how small you make it
will affect where it appears on the log scale; that's how logarithms work.

 

[Guest]

I had a feeling that is what the answer would be. If I do change the value
of my 0 to 10^-n, is there a way to remove the logs I do not need (ie go from
..00001 to 1 without the huge space in between)?

 

[David Biddulph]

You could probably use a broken axis:
http://peltiertech.com/Excel/Charts/BrokenYAxis.html

 

[Guest]

Thanks David!

You could probably use a broken axis:
http://peltiertech.com/Excel/Charts/BrokenYAxis.html