Share via


PivotField.ShowingInAxis Property

Excel Developer Reference

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

Version Information
 Version Added:  Excel 2007

Syntax

expression.ShowingInAxis

expression   A variable that represents a PivotField object.

Remarks

The 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 or not the PivotField caption is visible in the PivotTable in tabular (non-compact) form.

See Also