XlDataBarAxisPosition Enumeration
TOC
Collapse the table of content
Expand the table of content
The document is archived and information here might be outdated

XlDataBarAxisPosition Enumeration

Specifies the axis position for a range of cells with conditional formatting as data bars.

Version Added: Excel 2010

Name

Value

Description

xlDataBarAxisAutomatic

0

Display the axis at a variable position based on the ratio of the minimum negative value to the maximum positive value in the range. Positive values are displayed in a left-to-right direction. Negative values are displayed in a right-to-left direction. When all values are positive or all values are negative, no axis is displayed.

xlDataBarAxisMidpoint

1

Display the axis at the midpoint of the cell regardless of the set of values in the range. Positive values are displayed in a left-to-right direction. Negative values are displayed in a right-to-left direction.

xlDataBarAxisNone

2

No axis is displayed, and both positive and negative values are displayed in the left-to-right direction.

Show:
© 2016 Microsoft