In the x axis, logarithmic scale

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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 -

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
 
Charles said:
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?
Click to expand...

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?]
 
Back
Top