DataBar Properties |
The DataBar type exposes the following members.
Properties
| Name | Description | |
|---|---|---|
|
AxisColor |
Gets the color of the axis for cells with conditional formatting as data bars.
|
|
|
AxisPosition |
Gets or sets the position of the axis of the data bars specified by a conditional formatting rule.
|
|
|
BarBorder |
Gets an object that specifies the border of a data bar.
|
|
|
BarColor |
Gets or sets the color of the bar in a data bar condition format.
|
|
|
BarFillType |
Gets or sets the type of fill for the data bar.
|
|
|
Direction |
Gets or sets the direction the databar is displayed.
|
|
|
MaxPoint |
The longest bar is evaluated for a data bar conditional format.
|
|
|
MinPoint |
The shortest bar is evaluated for a data bar conditional format.
|
|
|
NegativeBarFormat |
Gets the NegativeBarFormat object associated with a data bar conditional formatting rule.
|
|
|
PercentMax |
Gets or sets a value that specifies the length of the longest data bar as a percentage of cell width.
|
|
|
PercentMin |
Gets or sets a value that specifies the length of the shortest data bar as a percentage of cell width.
|
|
|
ShowValue |
Gets or sets a Boolean value that specifies if the value in the cell is displayed.
|
See Also
