Partager via

Axis.MajorGridlines Property (Excel)

  • Article

Returns a Gridlines object that represents the major gridlines for the specified axis. Only axes in the primary axis group can have gridlines. Read-only.

Syntax

expression .MajorGridlines

expression A variable that represents an Axis object.

Example

This example sets the color of the major gridlines for the value axis in Chart1.

With Charts("Chart1").Axes(xlValue) 
 If .HasMajorGridlines Then 
 .MajorGridlines.Border.ColorIndex = 5 'set color to blue 
 End If 
End With

See Also

Concepts

Axis Object

Axis Object Members