HasPivotFields Property

Microsoft Excel Visual Basic

True if the PivotChart controls are displayed on the specified PivotChart report. The default value is True. For a regular chart, this property always returns False and cannot be set. Read/write Boolean.

Example

This example disables the PivotChart controls on the Sales chart in the 1996 Report workbook.

Workbooks("1996 Report").Charts("Sales") _
    .PivotLayout.HasPivotFields = False