MinorUnit Property

Returns or sets the minor unit for the specified axis. Use this property only with a value axis. Read/write Double.

expression   Required. An expression that returns a ChAxis object.

Remarks

Setting this property causes the HasAutoMinorUnit property to be set to False.

Example

This example sets the major and minor unit for the value axis.

Sub SetValueAxis()
   Dim chConstants
   Dim axValueAxis

   Set chConstants = ChartSpace1.Constants

   Set axValueAxis = ChartSpace1.Charts(0).Axes(chConstants.chAxisPositionValue)

   axValueAxis.MajorUnit = 7
   axValueAxis.MinorUnit = 2.5
End Sub