Gridlines object (Word)
Represents major or minor gridlines on a chart axis.
Gridlines extend the tick marks on a chart axis to make it easier to see the values associated with the data markers. This object is not a collection. There is no object that represents a single gridline; you either enable all gridlines for an axis or disable all of them.
Use the MajorGridlines property to return the GridLines object that represents the major gridlines for the axis. Use the MinorGridlines property to return the GridLines object that represents the minor gridlines. It is possible to return both major and minor gridlines at the same time.
The following example enables major gridlines for the category axis of the first chart in the active document and then formats the gridlines to be blue dashed lines.
With ActiveDocument.InlineShapes(1)
If .HasChart Then
With .Chart.Axes(xlCategory)
.HasMajorGridlines = True
.MajorGridlines.Border.Color = RGB(0, 0, 255)
.MajorGridlines.Border.LineStyle = xlDash
End With
End If
End With
Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.