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.