HideSelection (Method)

Applies To:

AxisLabels (XLabels, Ylabels and ZLabels)

Description:

Enables you to conceal label value items. Use this method to concentrate your view on selected item(s). To hide a Chart YFact object, use the YFact. Although XLabels and ZLabels behavior is simple (labels on the X and Z axis, i.e. Q1, Q2 ...), the behavior of YLabels is more complex. YLabels are the layers in the Y direction. For example, a stack bar could have 3 layers in the Y direction although there are two items in the YFact outliner.

Syntax:

Expression.HideSelection(ItemArray As Value)

Expression Required:

An expression that hides a LabelValues item

Example:

This example shows how to include LabelValues items 1 and 3 in an array but hide them in the Chart:

var NewArray = new Array()
NewArray[0]=ActiveDocument.Sections["AllChart"].XLabels.LabelValues.Item(1)
NewArray[1]=ActiveDocument.Sections["AllChart"].XLabels.LabelValues.Item(2)
ActiveDocument.Sections["AllChart"].XLabels.HideSelection(NewArray)