View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.charting
E[_2_] E[_2_] is offline
external usenet poster
 
Posts: 40
Default 0 on a logarithmic axis

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