This topic has not yet been rated - Rate this topic

Axis.MinorGridlines Property (Excel)

Published: July 16, 2012

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

expression .MinorGridlines

expression A variable that represents an Axis object.

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

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

Community Additions

© 2014 Microsoft. All rights reserved.