Edit

Share via


Left property (Excel Graph)

The Left property as it applies to the following objects.

Application and Datasheet objects

Returns or sets the distance from the left edge of the screen to the left edge of the main Graph window. Read/write Double.

Syntax

expression.Left

expression An expression that returns the Application or DataSheet object.

Remarks

If the window is maximized, Application.Left returns a negative number that varies based on the width of the window border. Setting Application.Left to 0 (zero) will make the window a tiny bit smaller than it would be if the application window were maximized. In other words, if Application.Left is 0, the left border of the main Graph window will just barely be visible on the screen.

If the Graph window is minimized, Application.Left controls the position of the window icon.

AxisTitle, ChartArea, ChartTitle, DataLabel, DisplayUnitLabel, Legend, and PlotArea objects

Returns or sets the distance from the left edge of the object to the left edge of the chart area. Read/write Double.

Syntax

expression.Left

expression Required. An expression that returns one of the above objects.

Example

This example aligns the left edge of the chart title with the left edge of the chart area.

myChart.ChartTitle.Left = 0 

Axis, LegendEntry, and LegendKey objects

Returns or sets the distance from the left edge of the object to the left edge of the chart area. Read-only Double.

Syntax

expression.Left

expression Required. An expression that returns one of the above objects.

Chart object

Returns or sets the distance from the left edge of the object to the left edge of the Graph window. Read/write Variant.

Syntax

expression.Left

expression Required. An expression that returns a Chart object.

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.