software

I have a problem on setting the scale of X amp; Y axis of the scatter
chart. I found that the scale of the X amp; Y axis of the scatter chart
are not consistent. For example, 10cm represents 100 units on the
Y-axis , however, 10cm represents 500 units on the X-axis. How can I
set the X amp; Y axis with the same scale. This is a very urgent case, as
I need to submit the graph to my supervisor within a hour. Please help
to solve it.

Thank you

Eugene--
chanyke
------------------------------------------------------------------------
chanyke's Profile: www.excelforum.com/member.php...oamp;userid=33910
View this thread: www.excelforum.com/showthread...hreadid=536855quot;chanykequot; gt; wrote in
message ...
gt;
gt; I have a problem on setting the scale of X amp; Y axis of the scatter
gt; chart. I found that the scale of the X amp; Y axis of the scatter chart
gt; are not consistent. For example, 10cm represents 100 units on the
gt; Y-axis , however, 10cm represents 500 units on the X-axis. How can I
gt; set the X amp; Y axis with the same scale. This is a very urgent case, as
gt; I need to submit the graph to my supervisor within a hour. Please help
gt; to solve it.

One way is to use the drawing toolbar, draw a square (shift-rectangle), then
adjust the scales of your axes to get the divisions matching the square. I
don't think there's an automatic way of doing it.
--
David Biddulph
Eugene:
Excel sets its axis scales to the values it needs to display by deafult.
You can manually adjust the scale by right-clicking the axis, selecting
Format Axis/Scale and setting the appropriate values for minimum and maximum.
GL,
Henk

quot;chanykequot; wrote:

gt;
gt; I have a problem on setting the scale of X amp; Y axis of the scatter
gt; chart. I found that the scale of the X amp; Y axis of the scatter chart
gt; are not consistent. For example, 10cm represents 100 units on the
gt; Y-axis , however, 10cm represents 500 units on the X-axis. How can I
gt; set the X amp; Y axis with the same scale. This is a very urgent case, as
gt; I need to submit the graph to my supervisor within a hour. Please help
gt; to solve it.
gt;
gt; Thank you
gt;
gt; Eugene
gt;
gt;
gt; --
gt; chanyke
gt; ------------------------------------------------------------------------
gt; chanyke's Profile: www.excelforum.com/member.php...oamp;userid=33910
gt; View this thread: www.excelforum.com/showthread...hreadid=536855
gt;
gt;


Thank you for all the replies.

Eugene--
chanyke
------------------------------------------------------------------------
chanyke's Profile: www.excelforum.com/member.php...oamp;userid=33910
View this thread: www.excelforum.com/showthread...hreadid=536855