XlDataBarNegativeColorType enumeration (Excel)

Specifies whether to use the same border and fill color as positive data bars.

Name Value Description
xlDataBarColor 0 Use the color specified in the Negative Value and Axis Setting dialog box or by using the ColorType and BorderColorType properties of the NegativeBarFormat object.
xlDataBarSameAsPositive 1 Use the same color as positive data bars.

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.