In the x axis, logarithmic scale

As previously reported, I used scatter chart. However, my data are bellow 1
(0.1; 0.5) and my y axis is in the middle of the chart. How can I put Y axis
on the left keeping these values?
Thanks

Charles -

To change the location of the Y axis on an XY (Scatter) chart, select the
horizontal X axis, choose Format Selected Axis | Scale, uncheck the box for
"Value (Y) Axis Crosses At," and specify an X value.

- Mike
www.mikemiddleton.com

"Charles" <Charles@discussions.microsoft.com> wrote in message
news:9D9C9721-D0E9-439B-9A85-159BFA940254@microsoft.com...
> As previously reported, I used scatter chart. However, my data are bellow
> 1
> (0.1; 0.5) and my y axis is in the middle of the chart. How can I put Y
> axis
> on the left keeping these values?
> Thanks

Charles -

For a log X axis of an XY (Scatter) chart, on the Format Axis | Scale tab,
you should specify both the "Minimum" value and the "Value (Y) Axis Crosses
At" value.

Also, Excel will use only multiples of 10 on the log X axis. So, for
example, you might specify 0.01 or 0.001.

- Mike
www.mikemiddleton.com

"Mike Middleton" <mike@mikemiddleton.com> wrote in message
news:%236YXZxJZGHA.5004@TK2MSFTNGP02.phx.gbl...
> Charles -
>
> To change the location of the Y axis on an XY (Scatter) chart, select the
> horizontal X axis, choose Format Selected Axis | Scale, uncheck the box
> for "Value (Y) Axis Crosses At," and specify an X value.
>
> - Mike
> www.mikemiddleton.com
>
> "Charles" <Charles@discussions.microsoft.com> wrote in message
> news:9D9C9721-D0E9-439B-9A85-159BFA940254@microsoft.com...
>> As previously reported, I used scatter chart. However, my data are bellow
>> 1
>> (0.1; 0.5) and my y axis is in the middle of the chart. How can I put Y
>> axis
>> on the left keeping these values?
>> Thanks
>
>

"Charles" <Charles@discussions.microsoft.com> wrote in message
news:9D9C9721-D0E9-439B-9A85-159BFA940254@microsoft.com...
> As previously reported, I used scatter chart. However, my data are bellow
> 1
> (0.1; 0.5) and my y axis is in the middle of the chart. How can I put Y
> axis
> on the left keeping these values?

Right Click on the X-axis.
Format Axis
Scale
Value (Y) axis crosses at: [choose which X value you want your Y axis;
possibly your minimum X value?]
--
David Biddulph