# GC.Spread.Sheets.ConditionalFormatting.DataBarAxisPosition

## Content

# Enumeration: DataBarAxisPosition

[Sheets](../modules/GC.Spread.Sheets).[ConditionalFormatting](../modules/GC.Spread.Sheets.ConditionalFormatting).DataBarAxisPosition

Specifies the position of the data bar's axis.

**`example`**
```
//This example creates a data bar rule.
activeSheet.setValue(0,0,1,3);
activeSheet.setValue(1,0,15,3);
activeSheet.setValue(2,0,25,3);
activeSheet.setValue(3,0,-1,3);
var dataBarRule = new GC.Spread.Sheets.ConditionalFormatting.DataBarRule();
dataBarRule.ranges([new GC.Spread.Sheets.Range(0,0,4,1)]);
dataBarRule.minType(GC.Spread.Sheets.ConditionalFormatting.ScaleValueType.number);
dataBarRule.minValue(-1);
dataBarRule.maxType(GC.Spread.Sheets.ConditionalFormatting.ScaleValueType.number);
dataBarRule.maxValue(40);
dataBarRule.color("green");
dataBarRule.showBorder(true);
dataBarRule.borderColor("orange");
dataBarRule.dataBarDirection(GC.Spread.Sheets.ConditionalFormatting.BarDirection.leftToRight);
dataBarRule.negativeFillColor("yellow");
dataBarRule.useNegativeFillColor(true);
dataBarRule.negativeBorderColor("red");
dataBarRule.useNegativeBorderColor(true);
dataBarRule.axisPosition(GC.Spread.Sheets.ConditionalFormatting.DataBarAxisPosition.automatic);
dataBarRule.axisColor("blue");
dataBarRule.showBarOnly(false);
activeSheet.conditionalFormats.addRule(dataBarRule);
```

## Table of contents

### Enumeration members

- [automatic](GC.Spread.Sheets.ConditionalFormatting.DataBarAxisPosition#automatic)
- [cellMidPoint](GC.Spread.Sheets.ConditionalFormatting.DataBarAxisPosition#cellmidpoint)
- [none](GC.Spread.Sheets.ConditionalFormatting.DataBarAxisPosition#none)

## Enumeration members

### <a id="automatic" name="automatic"></a> automatic

• **automatic** = `0`

Specifies whether to display at a variable position based on negative values.

___

### <a id="cellmidpoint" name="cellmidpoint"></a> cellMidPoint

• **cellMidPoint** = `1`

Specifies whether to display at the cell midpoint.

___

### <a id="none" name="none"></a> none

• **none** = `2`

Specifies whether to display value bars in the same direction as positive values.