ChartObject.Placement Property

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

See Also

• ChartObject Object
• ChartObject Object Members