0 on a logarithmic axis

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

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.
--
David Biddulph

"E" wrote in message
news
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

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" wrote:

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.
--
David Biddulph

"E" wrote in message
news
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

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

"E" wrote in message
...
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" wrote:

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.
--
David Biddulph

"E" wrote in message
news
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

Thanks David!

"David Biddulph" wrote:

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

"E" wrote in message
...
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" wrote:

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.
--
David Biddulph

"E" wrote in message
news 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