OLEObjects.Placement (Excel)
Returns or sets a Variant value containing an XlPlacement constant that represents the way the xlplacement is attached to the cells below it. Possible return values are xlFreeFloating - Object is free floating, xlMove - Object is moved with the cells, xlMoveAndSize - Object is moved and sized with the cells.
ActiveChart.OLEObjects.Placement = xlFreeFloating