RowAxis Property

Microsoft Office Web Components Visual Basic

object that represents the row axis.

PivotView object: Returns a PivotGroupAxis object that represents the row axis.

expression.RowAxis

expression    Required. An expression that returns one of the object in the Applies To list.

Example

This example inserts two field sets into the PivotTable list in the active view.

Sub AddFieldsToPT()

   Dim ptView

   Set ptView = PivotTable1.ActiveView

   ptView.ColumnAxis.InsertFieldSet ptView.FieldSets("Store Type")

   ptView.RowAxis.InsertFieldSet ptView.FieldSets("Promotions")

End Sub