Information
The topic you requested is included in another documentation set. For convenience, it's displayed below. Choose Switch to see the topic in its original location.

PivotField.ShowingInAxis Property

Office 2007
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.




Community Additions

Show: