PivotField.ShowingInAxis (Excel)

Indicates if the PivotField is currently visible in the PivotTable or not.

This property returns True if the PivotField is currently visible and returns False if the PivotField is currently not visible. The visibility of the PivotField is determined by whether the PivotField caption is visible in the PivotTable in tabular (non-compact) form.

Dim booShowingInAxis As Boolean
booShowingInAxis = ActiveCell.PivotField.ShowingInAxis