Compartilhar via


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.

See Also

Reference

Databar Interface

Databar Members

Microsoft.Office.Interop.Excel Namespace