how can i make a squared chart area

[squared chart area]

Hi,
am drowing lorenz curve and i need to make the length of the X-Axis of my
chart exactly equals the length of the Y-Axis.

 

[Andy Pope]

Hi,

To make sure the area is exactly equal will need a little VBA code.
Select the chart and run this routine.

Sub SquarePlotarea()

With ActiveChart.PlotArea
.Width = .Height
If .Width <> .Height Then .Height = .Width
End With

End Sub

Cheers
Andy