Does anybody know how to control "Size with Chart" property of format picture in VBA?
Printable View
Does anybody know how to control "Size with Chart" property of format picture in VBA?
I found the solution after some trials.
ActiveChart.Shapes.Range(Array("chart")).Select
Selection.ShapeRange.LockAspectRatio = msoFalse
Selection.Placement = xlMoveAndSize 'xlFreeFloating: Do not size with chart. 'xlMoveAndSize: Size with Chart