PDA

View Full Version : Size with Chart property of format picture in VBA



jaywang2000
11-08-2018, 07:12 PM
Does anybody know how to control "Size with Chart" property of format picture in VBA?

jaywang2000
11-12-2018, 01:42 AM
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