Description
Represents major gridlines 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. There is no singular GridLine object; you must turn all gridlines for an axis on or off at once.
Accessors
The MajorGridlines property returns the major gridlines for the axis. The MinorGridlines property returns the minor gridlines. There is no GridLines property or collection; you must access the major and minor gridlines separately.
The following example turns on major gridlines for the category axis on the chart sheet named "Chart1" and then formats the gridlines to be blue dashed lines.
Charts("chart1").Axes(xlCategory).HasMajorGridlines = True Charts("chart1").Axes(xlCategory).MajorGridlines.Border.Color = _ RGB(0, 0, 255) Charts("chart1").Axes(xlCategory).MajorGridlines.Border.LineStyle = _ xlDash
Properties
Application Property, Border Property, Creator Property, Name Property, Parent Property.
Methods
Delete Method, Select Method.