SparkVerticalAxis.CustomMaxScaleValue property (Excel)

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



expression A variable that represents a SparkVerticalAxis object.

Return value



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.