Databar.AxisPosition Property

Reference

Definition

Namespace:: Microsoft.Office.Interop.Excel

Assembly:: Microsoft.Office.Interop.Excel.dll

Important

Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.

Gets or sets the position of the axis of the data bars specified by a conditional formatting rule.

public:
 property Microsoft::Office::Interop::Excel::XlDataBarAxisPosition AxisPosition { Microsoft::Office::Interop::Excel::XlDataBarAxisPosition get(); void set(Microsoft::Office::Interop::Excel::XlDataBarAxisPosition value); };

public Microsoft.Office.Interop.Excel.XlDataBarAxisPosition AxisPosition { get; set; }

Public Property AxisPosition As XlDataBarAxisPosition

Property Value

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.

Applies to