Expand Minimize
This topic has not yet been rated - Rate this topic

Axis.HasMinorGridlines Property (Excel)

Published: July 16, 2012

True if the axis has minor gridlines. Only axes in the primary axis group can have gridlines. Read/write Boolean.

expression .HasMinorGridlines

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 = 4 
 'set color to green 
 End If 
End With
Did you find this helpful?
(1500 characters remaining)
© 2013 Microsoft. All rights reserved.