MaxLabelMode Property

The MaxLabelMode property returns or sets an axis tick label's Max label value to use automatic or custom values. Returns a Long.

Syntax

object.MaxLabelMode

object.MaxLabelMode = MaxLabelMode

 

Parameter Type Description
MaxLabelMode Long required, grfLabelRange

 

Example 1

This example shows how to return the axis label value mode.

Debug.Print TickLabels.MaxLabelMode

Example 2

This example shows how to set the maximum axis label value to a custom value of 4.

TickLabels.MaxLabelMode = grfLabelCustom

TickLabels.MaxLabelValue = 4

 

Used by: AutoAxisTickLabels object