Chart scale-length help.
 

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

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