software

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
quot;Value (Y) Axis Crosses At,quot; and specify an X value.

- Mike
www.mikemiddleton.com

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

For a log X axis of an XY (Scatter) chart, on the Format Axis | Scale tab,
you should specify both the quot;Minimumquot; value and the quot;Value (Y) Axis Crosses
Atquot; 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

quot;Mike Middletonquot; gt; wrote in message
...
gt; Charles -
gt;
gt; To change the location of the Y axis on an XY (Scatter) chart, select the
gt; horizontal X axis, choose Format Selected Axis | Scale, uncheck the box
gt; for quot;Value (Y) Axis Crosses At,quot; and specify an X value.
gt;
gt; - Mike
gt; www.mikemiddleton.com
gt;
gt; quot;Charlesquot; gt; wrote in message
gt; ...
gt;gt; As previously reported, I used scatter chart. However, my data are bellow
gt;gt; 1
gt;gt; (0.1; 0.5) and my y axis is in the middle of the chart. How can I put Y
gt;gt; axis
gt;gt; on the left keeping these values?
gt;gt; Thanks
gt;
gt;
quot;Charlesquot; gt; wrote in message
...
gt; As previously reported, I used scatter chart. However, my data are bellow
gt; 1
gt; (0.1; 0.5) and my y axis is in the middle of the chart. How can I put Y
gt; axis
gt; 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