Share via

ChartObject.Left Property

  • Article
Excel Developer Reference

Returns or sets a Double value that represents the distance, in points, from the left edge of the object to the left edge of column A (on a worksheet) or the left edge of the chart area (on a chart).

Syntax

expression.Left

expression   A variable that represents a ChartObject object.

Example
This example aligns the left edge of the embedded chart with the left edge of column B.

Visual Basic for Applications 
  With Worksheets("Sheet1")
    .ChartObjects(1).Left = .Columns("B").Left
End With

See Also