Placement Property
Applies To
ChartObject object, ChartObjects collection object, OLEObject object, OLEObjects collection object, Shape object.
Description
Returns or sets the way the object is attached to the cells below it. Can be one of the following XlPlacement constants: xlMoveAndSize, xlMove, or xlFreeFloating. Can be used only on objects on a worksheet. Read/write Long.
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