MinorTickMarks Property

  • Article

ChartTickMarkEnum

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

Applies to | ChAxis Object

See Also | MajorTickMarks Property