how can i make a squared chart area

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 
Back
Top