.
| ChartTickMarkEnum can be one of these ChartTickMarkEnum constants. |
| chTickMarkAutomatic |
| chTickMarkCross |
| chTickMarkInside |
| chTickMarkNone |
| chTickMarkOutside |
expression.MinorTickMarks
expression Required. An expression that returns a ChAxis object.
Example
This example turns on minor gridlines and minor tick marks for the specified axis and sets the gridline color and tick-mark style.
Sub FormatValueAxis()
Dim chConstants
Dim axValueAxis
Set chConstants = ChartSpace1.Constants
Set axValueAxis = ChartSpace1.Charts(0).Axes(chConstants.chAxisPositionLeft)
axValueAxis.HasMinorGridlines = True
axValueAxis.MinorGridlines.Line.Color = "green"
axValueAxis.MinorTickMarks = chConstants.chTickMarkOutside
End Sub