Negative or zero values cannot be plotted correctly on log charts



Excel 2002 SP3.

This maybe a stupid question (I'm not a statistician or mathematician).

I have data that looks like this:

Na 0.032617
Cl 0.0265
Ca 0.000524
K 0.005523
Mg 0.0000823
PO4 0.00031
HCO3 0.001655

I am plotting it with categorical values on the xaxis and the numerical
value on the y axis. I am using a logarithmic scale for the y axis.

I am getting the "Negative or zero values cannot be plotted correctly
on log charts. Only positive values can be interpreted on a
logarithmic scale" message, which I see from the newsgroup is common if
there are zeros in the data. However, the data I am using does not
appear to be zero to me. All the numbers are positive, even if they
are small.

So why am I getting this message?

Thank you.
Nicole

.



Relevant Pages

  • Sunrise and Sunset Calculation
    ... etc) location on the earth. ... period, axis tilt, etc) might need to be updated for 2009. ... date June 14th as one of those times when there is zero error. ... orbit of the sun. ...
    (sci.astro.amateur)
  • Minus Zero??? Yes indeedy....
    ... 4th axis, and am having a helluva time with this thing spinning the "wrong" ... Until I discovered Minus Zero. ... Stop Corruption in Congress & Send the Ultimate Message: ... Ending Corruption in Congress is the *Single Best Way* ...
    (alt.machines.cnc)
  • Re: Built-ins Versus User-defined
    ... I am quoting the manual, although paraphrasing might be a better term, since I have specialized to the case that the right argument is a vector with non zero length. ... First of all the in the second set of parentheses is obviously a typo; in fact it surely is a misplaced correction to the omission of in the similar definition of scan with axis on the next page, ... The LRM clearly states that the order of expression evaluation is always to apply next the rightmost function whose argumentis/are available. ... I don't have an IBM APL2 reference maunal ...
    (comp.lang.apl)
  • Re: Hamming window
    ... I'm having difficulty labelling and converting my x axis. ... This is also understood from sample rate 44100 divided by number of values ... The normal representation is from zero to fs/2 and from fs-fs/2 to fs ...
    (comp.dsp)
  • Re: David Dryden - Searching All of Sequence Space
    ... sea level is above the zero of the y axis. ... After all, the exponential decay was the decay of a probability, while ... That is why he uses the 'islands of functionality' metaphor. ...
    (talk.origins)