Chart.PivotLayout Property (Excel)


Contribute to this content

Use GitHub to suggest and submit changes. See our guidelines for contributing to VBA documentation.

Returns a PivotLayout object that represents the placement of fields in a PivotTable report and the placement of axes in a PivotChart report. Read-only.

expression .PivotLayout

expression A variable that represents a Chart object.

If the chart you specify isn’t a PivotChart report, the value of this property is Nothing.

This example creates a list of all the PivotTable field names used in the first PivotChart report.

Set objNewSheet = Worksheets.Add 
intRow = 1 
For Each objPF In _ 
 objNewSheet.Cells(intRow, 1).Value = objPF.Caption 
 intRow = intRow + 1 
Next objPF


Other resources

© 2015 Microsoft