YLabels (Object)

Member of:

ChartSection object

Description:

Represents a label value on the Y axis. This object’s properties directly affect the display of the label on the Z axis and correspond to the options provided on the Chart menu or shortcut menu.

Note:

You must specify the label values in an array before using the FocusSelection (Method), HideSelection (Method), and UnHide (Method).

Example:

This example shows how to modify the label value on the Y axis:

var OArray = new Array()
OArray[0]= ActiveDocument.Sections["Chart"].YLabels.LabelValues.Item(1)
OArray[1]= ActiveDocument.Sections["Chart"].YLabels.LabelValues.Item(3)
var ZArray = new Array()
ZArray[0]= ActiveDocument.Sections["Chart"].YLabels.LabelValues.Item(2)
ZArray[1]= ActiveDocument.Sections["Chart"].YLabels.LabelValues.Item(4)
ActiveDocument.Sections["Chart"].YLabels.FocusSelection(OArray)
ActiveDocument.Sections["Chart"].YLabels.HideSelection(ZArray)
ActiveDocument.Sections["Chart"].YLabels.UnhideAll(ZArray)

Methods:

DrillInto(Value as NameOrIndex, DrillName As String), FocusSelection(Value As ItemArray), HideSelection(Value as ItemArray), UnhideAll()

Properties:

Read-only: Property Count as Number

Objects:

LabelValues As LabelValues