ColumnAxis Property

  • Article

This content is no longer actively maintained. It is provided as is, for anyone who may still be using these technologies, with no warranties or claims of accuracy with regard to the most recent product version or service release.

PivotData object: Returns a PivotResultColumnAxis 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