HasPivotFields Property Example

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

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