Maximum Property

expression.Maximum

expression    Required. An expression that returns a ChScaling object.

Example

This example sets the maximum and minimum values for the specified axis scale.

Sub SetScalingLimits()
   Dim chConstants
   Dim axisScale

   Set chConstants = ChartSpace1.Constants

   Set axisScale = ChartSpace1.Charts(0).Axes(chConstants.chAxisPositionValue).Scaling

   axisScale.Maximum = 70
   axisScale.Minimum = -10
End Sub0