Home Library Learn Samples Downloads Support Community Forums
MSDN Library
Office and SharePoint development
Office client development
Office 2013
Excel 2013
Welcome to the Excel 2013 developer reference
Object model reference (Excel 2013 developer reference)
Axis Object (Excel)
Axis Properties (Excel)
Axis.Application Property (Excel)
Axis.AxisBetweenCategories Property (Excel)
Axis.AxisGroup Property (Excel)
Axis.AxisTitle Property (Excel)
Axis.BaseUnit Property (Excel)
Axis.BaseUnitIsAuto Property (Excel)
Axis.Border Property (Excel)
Axis.CategoryNames Property (Excel)
Axis.CategoryType Property (Excel)
Axis.Creator Property (Excel)
Axis.Crosses Property (Excel)
Axis.CrossesAt Property (Excel)
Axis.DisplayUnit Property (Excel)
Axis.DisplayUnitCustom Property (Excel)
Axis.DisplayUnitLabel Property (Excel)
Axis.Format Property (Excel)
Axis.HasDisplayUnitLabel Property (Excel)
Axis.HasMajorGridlines Property (Excel)
Axis.HasMinorGridlines Property (Excel)
Axis.HasTitle Property (Excel)
Axis.Height Property (Excel)
Axis.Left Property (Excel)
Axis.LogBase Property (Excel)
Axis.MajorGridlines Property (Excel)
Axis.MajorTickMark Property (Excel)
Axis.MajorUnit Property (Excel)
Axis.MajorUnitIsAuto Property (Excel)
Axis.MajorUnitScale Property (Excel)
Axis.MaximumScale Property (Excel)
Axis.MaximumScaleIsAuto Property (Excel)
Axis.MinimumScale Property (Excel)
Axis.MinimumScaleIsAuto Property (Excel)
Axis.MinorGridlines Property (Excel)
Axis.MinorTickMark Property (Excel)
Axis.MinorUnit Property (Excel)
Axis.MinorUnitIsAuto Property (Excel)
Axis.MinorUnitScale Property (Excel)
Axis.Parent Property (Excel)
Axis.ReversePlotOrder Property (Excel)
Axis.ScaleType Property (Excel)
Axis.TickLabelPosition Property (Excel)
Axis.TickLabels Property (Excel)
Axis.TickLabelSpacing Property (Excel)
Axis.TickLabelSpacingIsAuto Property (Excel)
Axis.TickMarkSpacing Property (Excel)
Axis.Top Property (Excel)
Axis.Type Property (Excel)
Axis.Width Property (Excel)
Expand Minimize
This topic has not yet been rated - Rate this topic

Axis.HasMinorGridlines Property (Excel)

Office 2013

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.

VBA
Copy 
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.
|
Site Feedback
© 2013 Microsoft. All rights reserved.