DataBarConditionalFormat Object (JavaScript API for Excel)
Represents an Excel Conditional Data Bar Type.
Properties
| Property | Type | Description | Req. Set |
|---|---|---|---|
| axisColor | string | HTML color code representing the color of the Axis line, of the form #RRGGBB (e.g. "FFA500") or as a named HTML color (e.g. "orange"). | 1.6 |
| axisFormat | string | Representation of how the axis is determined for an Excel data bar. Possible values are: Automatic, None, CellMidPoint. | 1.6 |
| barDirection | string | Represents the direction that the data bar graphic should be based on. Possible values are: Context, LeftToRight, RightToLeft. | 1.6 |
| showDataBarOnly | bool | If true, hides the values from the cells where the data bar is applied. | 1.6 |
See property access examples.
Relationships
| Relationship | Type | Description | Req. Set |
|---|---|---|---|
| lowerBoundRule | ConditionalDataBarRule | The rule for what consistutes the lower bound (and how to calculate it, if applicable) for a data bar. | 1.6 |
| negativeFormat | ConditionalDataBarNegativeFormat | Representation of all values to the left of the axis in an Excel data bar. Read-only. | 1.6 |
| positiveFormat | ConditionalDataBarPositiveFormat | Representation of all values to the right of the axis in an Excel data bar. Read-only. | 1.6 |
| upperBoundRule | ConditionalDataBarRule | The rule for what constitutes the upper bound (and how to calculate it, if applicable) for a data bar. | 1.6 |
Methods
None