SparkVerticalAxis.CustomMaxScaleValue property (Excel)

Returns or sets the custom maximum value for the vertical axis of a sparkline. Read/write.

Syntax

expression.CustomMaxScaleValue

expression A variable that represents a SparkVerticalAxis object.

Return value

Variant

Remarks

The CustomMaxScaleValue property can be returned or set only when the MaxScaleType property of the specified SparkVerticalAxis object is set to xlSparkScaleCustom (3).

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.