PivotSection object, OLAPQuery object
Represents the Pivot or OLAPQuery data labels feature. Data labels are the column and row heading on the top and sides of a pivot report and define the categories for numeric values. You can include data labels on pivot reports and specify their position (none, top, side, or both).
In this example, data labels are displayed on the side of the pivot report:
ActiveDocument.Sections["Pivot"].DataLabels.Display= BqPivotLabelDisplaySide
In this example, data labels are displayed on the top of a pivot report:
ActiveDocument.Sections["Pivot"].DataLabels.Display= BqPivotLabelDisplayTop
In this example, data labels are displayed on the top and side of a report:
ActiveDocument.Sections["Pivot"].DataLabels.Display= BqPivotLabelDisplayBoth
In this example, data labels are hidden:
ActiveDocument.Sections["Pivot"].DataLabels.Display= BqPivotLabelDisplayNone
In this example, data labels are hidden:
ActiveDocument.Sections["Pivot"].DataLabels.Display= BqPivotLabelDisplayNone