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