ChartObjects.Placement Property (Excel)

  • Article

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

Syntax

expression .Placement

expression A variable that represents a ChartObjects object.

Example

This example sets the objects on Sheet1 to be free-floating (they neither moves nor are they sized with underlying cells).

Worksheets("Sheet1").ChartObjects.Placement = xlFreeFloating