Vyz,
Select the chart and run this macro. You can assign it to a keyboard
shortcut, toolbar button, menu item.
Sub SquarePlotArea()
ActiveChart.PlotArea.Width = ActiveChart.PlotArea.Height
End Sub
--
Earl Kiosterud
www.smokeylake.com
"Vyz" wrote in message
...
I have a made an x-y scatter chart in Excel but I want the x and y axis
to be of the same scale-length. Is there anyway to do this besides
fiddling with resizing manually?
Thanks in advance.
--
Vyz
------------------------------------------------------------------------
Vyz's Profile:
http://www.excelforum.com/member.php...o&userid=25127
View this thread: http://www.excelforum.com/showthread...hreadid=386290