Class PivotLayout (Excel VBA)

The class PivotLayout represents the placement of fields in a PivotChart report.

Item

To use a PivotLayout class variable it first needs to be instantiated, for example

Dim plt as PivotLayout
Set plt = ActiveChart.PivotLayout

PivotLayout class variables can be set using the Chart.PivotLayout procedure.

PivotTable

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

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