Exposes properties which control the appearance of negative-value data bars.

NegativeBarFormat

new NegativeBarFormat(a: DataBarConditionalFormat, b: object): NegativeBarFormat

Returns NegativeBarFormat

Returns a [[WorkbookColorInfo]] which defines the border color applied to data bars with a negative value.

get barBorderColor(): WorkbookColorInfo

Returns WorkbookColorInfo

set barBorderColor(a: WorkbookColorInfo): void

Parameters

Returns void

Returns or sets a [[DataBarNegativeBarColorType]] value which specifies whether the same border color as that which is used for data bars with positive cell values is also used for data bars with negative cell values.

get barBorderColorType(): DataBarNegativeBarColorType

Returns DataBarNegativeBarColorType

set barBorderColorType(a: DataBarNegativeBarColorType): void

Parameters

Returns void

Returns a [[WorkbookColorInfo]] which defines the fill color applied to data bars with a negative value.

get barColor(): WorkbookColorInfo

Returns WorkbookColorInfo

set barColor(a: WorkbookColorInfo): void

Parameters

Returns void

Returns or sets a [[DataBarNegativeBarColorType]] value which specifies whether the same color as that which is used for the positive data bars is used.

get barColorType(): DataBarNegativeBarColorType

Returns DataBarNegativeBarColorType

set barColorType(a: DataBarNegativeBarColorType): void

Parameters

Returns void