NegativeBarFormat

NegativeBarFormat class

Represents the color settings of the data bars for negative values that are defined by a data bar conditional formatting rule.

class NegativeBarFormat;

Methods

MethodDescription
getBorderColor()Gets or sets a FormatColor object that you can use to specify the border color for negative data bars.
setBorderColor(Color)Gets or sets a FormatColor object that you can use to specify the border color for negative data bars.
getBorderColorType()Gets whether to use the same border color as positive data bars.
setBorderColorType(DataBarNegativeColorType)Gets whether to use the same border color as positive data bars.
getColor()Gets or sets a FormatColor object that you can use to specify the fill color for negative data bars.
setColor(Color)Gets or sets a FormatColor object that you can use to specify the fill color for negative data bars.
getColorType()Gets or sets whether to use the same fill color as positive data bars.
setColorType(DataBarNegativeColorType)Gets or sets whether to use the same fill color as positive data bars.

getBorderColor()

Gets or sets a FormatColor object that you can use to specify the border color for negative data bars.

getBorderColor() : Color;

Returns

Color

setBorderColor(Color)

Gets or sets a FormatColor object that you can use to specify the border color for negative data bars.

setBorderColor(value: Color) : void;

Parameters:

ParameterTypeDescription
valueColorThe value to set.

getBorderColorType()

Gets whether to use the same border color as positive data bars.

getBorderColorType() : DataBarNegativeColorType;

Returns

DataBarNegativeColorType

setBorderColorType(DataBarNegativeColorType)

Gets whether to use the same border color as positive data bars.

setBorderColorType(value: DataBarNegativeColorType) : void;

Parameters:

ParameterTypeDescription
valueDataBarNegativeColorTypeThe value to set.

getColor()

Gets or sets a FormatColor object that you can use to specify the fill color for negative data bars.

getColor() : Color;

Returns

Color

setColor(Color)

Gets or sets a FormatColor object that you can use to specify the fill color for negative data bars.

setColor(value: Color) : void;

Parameters:

ParameterTypeDescription
valueColorThe value to set.

getColorType()

Gets or sets whether to use the same fill color as positive data bars.

getColorType() : DataBarNegativeColorType;

Returns

DataBarNegativeColorType

setColorType(DataBarNegativeColorType)

Gets or sets whether to use the same fill color as positive data bars.

setColorType(value: DataBarNegativeColorType) : void;

Parameters:

ParameterTypeDescription
valueDataBarNegativeColorTypeThe value to set.