Display (Property)

Applies To:

CornerLabels object, DataLabels object

Description:

Returns the display value of a corner or data label. The Display (Property) uses the BqPivotLabelDisplay constant. Valid options for displaying the label are side, top, both or none. The default corner label value is none.

Action:

Read-write, String

Constants:

The BqPivotLabelDisplay constant group consists of these values:

BqPivotLabelDisplayBoth
BqPivotLabelDisplayNone
BqPivotLabelDisplaySide
BqPivotLabelDisplayTop

Example:

This example shows how to return a corner label at the top of the Pivot report:

ActiveDocument.Sections["SalesPivot"].CornerLabels. Display=bqPivotLabelDisplayBoth