GrapeCity.Documents.Excel.IDataBar.AxisPosition

AxisPosition Property

AxisPosition

Gets or sets the axis position of the data bars in this conditional formatting rule.

The axis position controls how positive and negative data bars are separated within each cell. Use Automatic to place the axis based on the values in the range, Midpoint to keep the axis centered, or None to hide the axis.

Declaration

DataBarAxisPosition AxisPosition { get; set; }

Property AxisPosition As DataBarAxisPosition

Property Value

Type	Description
DataBarAxisPosition	A DataBarAxisPosition value that indicates where the data bar axis is displayed.

Examples

worksheet.Range["A1:A3"].Value = new object[,] {{-10}, {0}, {20}};
IDataBar dataBar = worksheet.Range["A1:A3"].FormatConditions.AddDatabar();
dataBar.AxisPosition = DataBarAxisPosition.Automatic;
DataBarAxisPosition axisPosition = dataBar.AxisPosition;