ChartObject.Placement Property (Excel)
Returns or sets a Variant value, containing an XlPlacement constant, that represents the way the object is attached to the cells below it.
Syntax
expression .Placement
expression A variable that represents a ChartObject object.
Example
This example sets embedded chart one on Sheet1 to be free-floating (it neither moves nor is sized with its underlying cells).
Worksheets("Sheet1").ChartObjects(1).Placement = xlFreeFloating