Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Scale on X & Y Axis of the scatter chart
I have a problem on setting the scale of X & Y axis of the scatter chart. I found that the scale of the X & 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 & 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: http://www.excelforum.com/member.php...o&userid=33910 View this thread: http://www.excelforum.com/showthread...hreadid=536855 |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Scale on X & Y Axis of the scatter chart
"chanyke" wrote in
message ... I have a problem on setting the scale of X & Y axis of the scatter chart. I found that the scale of the X & 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 & 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. 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 |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Scale on X & Y Axis of the scatter chart
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 "chanyke" wrote: I have a problem on setting the scale of X & Y axis of the scatter chart. I found that the scale of the X & 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 & 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: http://www.excelforum.com/member.php...o&userid=33910 View this thread: http://www.excelforum.com/showthread...hreadid=536855 |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
Scale on X & Y Axis of the scatter chart
Thank you for all the replies. Eugene -- chanyke ------------------------------------------------------------------------ chanyke's Profile: http://www.excelforum.com/member.php...o&userid=33910 View this thread: http://www.excelforum.com/showthread...hreadid=536855 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
X axis scale on an XY scatter plot | Charts and Charting in Excel | |||
Chart Axis Showing Lapse/Interupt Scale | Charts and Charting in Excel | |||
XY scatter and Bar chart - secondary axis misaligned | Charts and Charting in Excel | |||
XY scatter and Bar chart - secondary axis misaligned | Charts and Charting in Excel | |||
Scatter Chart Axis as text in C# Web appl | Charts and Charting in Excel |