Skip to content

Latest commit

 

History

History
40 lines (18 loc) · 1.01 KB

1d3e3557-66c5-78f8-a86c-c0d64af63bc6.md

File metadata and controls

40 lines (18 loc) · 1.01 KB

ChartObject.ZOrder Property (Excel)

Returns the z-order position of the object. Read-only Long .

Syntax

expression . ZOrder

expression A variable that represents a ChartObject object.

Remarks

In any collection of objects, the object at the back of the z-order is collection(1), and the object at the front of the z-order is collection( collection. Count ). For example, if there are embedded charts on the active sheet, the chart at the back of the z-order is ActiveSheet.ChartObjects(1), and the chart at the front of the z-order is ActiveSheet.ChartObjects(ActiveSheet.ChartObjects.Count).

Example

This example displays the z-order position of embedded chart one on Sheet1.

MsgBox "The chart's z-order position is " & _ 
 Worksheets("Sheet1").ChartObjects(1).ZOrder

See also

Concepts

ChartObject Object

Other resources

ChartObject Object Members