Chart scale-length help.

V

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.
 
E

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
 
Top