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