Chart scale-length help.

[Vyz]

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.

[Earl Kiosterud]

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" <[email protected]> wrote in message
news:[email protected]...
>
> 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
>