# How to preserve points near zero when taking logs? [duplicate]

Possible Duplicate:
How should I transform non-negative data including zeros?

I have a question:

Suppose we have a data point $(0,10)$. We then convert to a log scale. Excel gets rid of this data point since the minimum x-value is $1$. How do we keep this data point?

Edit. Can't you change the x-coordinate to $1$? So instead we have $(1,10)$ instead of $(0,10)$. The rest of the values are not changed.

-
You can't take the log of 0, so you can't keep that data point if you want to take logs. –  Peter Flom Oct 11 '12 at 13:12
This Q will also be helpful for you: How small a quantity should be added to x to avoid taking the log of zero. –  gung Oct 11 '12 at 13:20