ColumnAxis Property

Microsoft Office Web Components Visual Basic

object that represents the column axis in the specified PivotTable list.

PivotView object: Returns a PivotGroupAxis object that represents the column axis in the specified PivotTable list.

expression.ColumnAxis

expression    Required. An expression that returns a PivotData or PivotView object.

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