how do i alter a chart's width and height?

[kylefoley76]

i want my chart to take up more of the sheet. how do i do that? i'm using excel for mac 2010 but hopefully i can translate the specifications from pc to mac.

 

[VoG]

Try like this

Sub chartsize()
With ActiveSheet.ChartObjects("Chart 1")
    .Height = 300
    .Width = 500
End With
End Sub

 

[jdawg_1989]

Can't you just use the handles to drag to size? Or am I missing the point here?