PivotTo (Method)

Applies To:

PivotLabel collection

Description:

Changes the position of a pivot label. By default, calling the PivotTo method moves a pivot label from one label collection to another. PivotTo performs the same action as selecting or deleting a pivot label from one group and reinserting into a different group.

Syntax:

Expression.PivotTo([Index As Number])

Expression Required:

An expression that returns a PivotLabel object

Example:

This example shows how to pivot a label from the top labels collection to the 1st position in the side labels collection. The Index is an optional property, which specifies where the label pivots. If the property is empty, then the pivot places the label at the end of the list:

ActiveDocument.Sections["Pivot"].TopLabels["Year"].PivotTo(1)
//To pivot back to its original position use:
ActiveDocument.Sections["Pivot"].TopLabels["Year"].PivotTo()