Databar.AxisPosition Property
Gets or sets the position of the axis of the data bars specified by a conditional formatting rule.
Namespace: Microsoft.Office.Interop.Excel
Assembly: Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)
Syntax
'Declaration
Property AxisPosition As XlDataBarAxisPosition
Get
Set
'Usage
Dim instance As Databar
Dim value As XlDataBarAxisPosition
value = instance.AxisPosition
instance.AxisPosition = value
XlDataBarAxisPosition AxisPosition { get; set; }
Property Value
Type: Microsoft.Office.Interop.Excel.XlDataBarAxisPosition
The position of the axis of the data bars specified by a conditional formatting rule.
Remarks
Read/write.
The axis for data bars is displayed only when the AxisPosition property is either xlDataBarAxisAutomatic or xlDataBarAxisMidpoint, and when there are negative values in the range of values specified with a data bar conditional formatting rule. The default value for the AxisPosition property is xlDataBarAxisAutomatic.