Microsoft Office Tutorials and References
In Depth Information
21.6.8 Position- and Dimension-Related Properties
This read-only property returns a Gridlines object that represents the major gridlines for
the specified axis. Applies only to primary axes (not secondary axes).
MinorGridlines
This read-only property returns a Gridlines object that represents the minor gridlines for
the specified axis. Applies only to primary axes (not secondary axes).
Note that the Gridlines object is not a collection object; that is, there is no Gridline object. Instead,
the properties of the Gridlines object apply to all of the gridlines for the axis. For instance, the
following code adds major gridlines to the category axis and formats these lines:
ActiveChart.Axes(xlCategory, xlPrimary). _
HasMajorGridlines = True
With ActiveChart.Axes(xlCategory, xlPrimary). _
MajorGridlines.Border
.Color = RGB(0, 0, 255)
.LineStyle = xlDot
.Weight = xlThick
End With
21.6.8 Position- and Dimension-Related Properties
The Axis object has the following properties related to its position and dimensions. These
properties are read-only.
Height
Returns the height of the axis in points.
Width
Returns the width of the axis in points.
Left
Returns the distance from the left edge of the axis to the left edge of the chart area.
Top
Returns the distance from the top edge of the axis to the top of the chart area.
(Note that the width of a vertical axis is 0 and the height of a horizontal axis is 0.)
21.6.9 Tick Mark-Related Properties
The Axis object has several properties related to tick marks. The MajorTickMark property returns
or sets the type of major tick mark for the specified axis, and the MinorTickMark property does
the same for minor tick marks. Each of these properties can assume any value from the following
enum:
Enum XlTickMark
xlTickMarkNone = -4142
xlTickMarkInside = 2
xlTickMarkOutside = 3
Search JabSto ::




Custom Search