View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Andy Pope Andy Pope is offline
external usenet poster
 
Posts: 2,489
Default 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.