Edit

Share via

PivotField.ShowingInAxis property (Excel)

  • Article

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

Syntax

expression.ShowingInAxis

expression A variable that represents a PivotField object.

Remarks

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.

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.