Edit

DataBar.PercentMin property (Excel)

  • Article

Returns or sets a Long value that specifies the length of the shortest data bar as a percentage of cell width.

Syntax

expression.PercentMin

expression A variable that represents a DataBar object.

Remarks

The value must be a whole number between 0 and 100. The default value is 0.

The effect of the PercentMin property varies depending on the setting of the AxisPosition property of the DataBar object.

When the AxisPosition property is xlDataBarAxisAutomatic and the range contains both positive and negative values, the minimum length of a positive or negative bar is specified by the PercentMin property, and the axis is displayed by using automatic centering rules.

When the AxisPosition property is xlDataBarAxisMidpoint, the minimum length of a positive or negative bar is specified by the PercentMin property, and the axis is centered in the middle of the cell.

When the AxisPosition property is xlDataBarAxisNone, the length of the shortest data bar is always the percentage of the cell width specified by the PercentMin property.

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.