Thread: How do I get VBA to generate a chart with square axes?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ardus Petus Ardus Petus is offline
external usenet poster
  
Posts: 718
Default How do I get VBA to generate a chart with square axes?
Try this:

'---------
Sub SquareChart()
With ActiveSheet.Shapes("Graphique 1")
.Height = .Width
End With
End Sub
'---------

Regards,
--
AP

"patrick" a écrit dans le message de
news: ...
I have generated a chart using Excel data but wish to ensure that the chart
is square (i.e. the x and the y axes are to the same scale). an anyone
help
please?


Reply With QuoteReply With Quote