how can i make a 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.

how can i make a squared chart area
 

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

squared chart area wrote:
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.