Databar.PercentMax Property (Excel)
Returns or sets a Long value that specifies the length of the longest data bar as a percentage of cell width.
Version Information
Version Added: Excel 2007
Syntax
expression .PercentMax
expression A variable that represents a Databar object.
Remarks
The value must be a whole number between 0 and 100. The default value is 100.
The effect of the PercentMax 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 sum of the lengths of longest positive data bar and the longest negative data bar will not exceed the value specified by the PercentMax property. When the AxisPosition property is xlDataBarAxisMidpoint, the longest data bar (positive or negative) will be equal to the value of the PercentMax property divided by 2. When the AxisPosition property is xlDataBarAxisNone, the length of the longest data bar is always the percentage of cell width specified by the PercentMax property.