Collapse the table of content
Expand the table of content
Expand Minimize

XlDataBarNegativeColorType Enumeration (Excel)

Office 2013 and later
GitHub-Mark-64px

Contribute to this content

Use GitHub to suggest and submit changes. See our guidelines for contributing to VBA documentation.

Specifies whether to use the same border and fill color as postive 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.

Show:
© 2016 Microsoft