ChartObjects.Placement procedure builder

ChartObjects.Placement (Excel)

Returns or sets a Variant value, containing an XlPlacement constant, that represents the way the xlplacements are attached to the cells below them.

xlFreeFloating - Object is free floating, xlMove - Object is moved with the cells, xlMoveAndSize - Object is moved and sized with the cells.
ActiveSheet.ChartObjects.Placement = xlFreeFloating