MajorUnit Property

Returns or sets the major 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 HasAutoMajorUnit 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