Represents labels for a chart axis, and maps to the Chart Outliner.
The AxisLabels (Collection) is instantiated three times for each Chart Section object in the form: XLabels, YLabels, and ZLabels.
All collections have the “Item(NameOrIndex)” method. This is the default method for all collections and returns an item in the collection at a particular index or with a specific name. Use brackets ([]) to represent the call to the Item (Method). For example, these statements cause identical behavior: myItem = Documents[1] myItem = Documents.Item(1) myItem = Documents["StartUp.bqy"] myItem = Documents.Item("StartUp.bqy") |
This example illustrates how count labels on the X-axis:
ActiveDocument.Sections["AllChart"].XLabels.Count
In this example, the Axis labels are left-justified and rotated vertically:
ActiveDocument.Sections["Chart"].XLabels.Orientation = bqChartLabelOrientationVertical ActiveDocument.Sections["Chart"].XLabels.Justification = bqLeftJustified
DrillInto(ItemNameOrIndex, DrillName As String), FocusSelection(ItemArray), HideSelection(ItemArray), UnhideAll()