Class PivotLayout (Excel VBA)

The class PivotLayout represents the placement of fields in a PivotChart report. To use a PivotLayout class variable it first needs to be instantiated, for example

Dim plt as PivotLayout
Set plt = ActiveChart.PivotLayout

PivotTable

Returns a PivotTable object that represents the PivotTable report associated with the PivotChart report.

Dim pvtPivotTable As PivotTable
Set pvtPivotTable = ActiveChart.PivotLayout.PivotTable