Axis.Crosses Property
Returns or sets the point on the specified axis where the other axis crosses.
Namespace: Microsoft.Office.Interop.Excel
Assembly: Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)
Syntax
'Declaration
Property Crosses As XlAxisCrosses
Get
Set
'Usage
Dim instance As Axis
Dim value As XlAxisCrosses
value = instance.Crosses
instance.Crosses = value
XlAxisCrosses Crosses { get; set; }
Property Value
Type: Microsoft.Office.Interop.Excel.XlAxisCrosses
Remarks
The Crosses property can be one of the XlAxisCrosses constants listed in the following table.
Constant |
Meaning |
|---|---|
xlAxisCrossesAutomatic |
Microsoft Excel sets the axis crossing point. |
xlMinimum |
The axis crosses at the minimum value. |
xlMaximum |
The axis crosses at the maximum value. |
xlAxisCrossesCustom |
The CrossesAt property specifies the axis crossing point. |
This property isn't available for radar charts. For 3-D charts, this property can only be applied to the value axis and indicates where the plane defined by the category axes crosses the value axis.
This property can be used for both category and value axes. On the category axis, xlMinimum sets the value axis to cross at the first category, and xlMaximum sets the value axis to cross at the last category.
Note that xlMinimum and xlMaximum can have different meanings, depending on the axis.