Thread: Semi logarithm chart

in order to create Semi logarithmic chart,
I created X,Y (scatter) chart.
I double clicked the X axis.
in the second tab ("scale") I checked the first checkbox "logarithmic scale"

the problem is that the y axis is located at x=1 (aee attach file)
can anybody help me?

Thanks
Aya.


the values:
100 0.89
50 0.75
25 0.67
12.5 0.62
6.25 0.54
3.125 0.46
1.5625 0.39
0.78125 0.31
0.390625 0.25
0.1953125 0.15

In the exact same dialog is an option for "value (Y) axis crosses at". Excel's "automatic" choice is 1, but you can set that to whatever you want. Just recognize that values <=0 have no meaning on a logarithmic axis, so you can't enter 0 or a negative number.