Excel.PivotLayout.md

title	keywords	f1_keywords	api_name	ms.assetid	ms.date	ms.localizationpriority
PivotLayout object (Excel)	vbaxl10.chm663072	vbaxl10.chm663072	Excel.PivotLayout	cfef617e-f49a-e969-7873-40593412a32e	03/30/2019	medium

PivotLayout object (Excel)

Represents the placement of fields in a PivotChart report.

Example

Use the PivotLayout property of the Chart object to return a PivotLayout object.

The following example creates a list of PivotTable field names used in the first PivotChart report.

Sub ListFieldNames 
 
 Dim objNewSheet As Worksheet 
 Dim intRow As Integer 
 Dim objPF As PivotField 
 
 Set objNewSheet = Worksheets.Add 
 
 intRow = 1 
 
 For Each objPF In _ 
 Charts("Chart1").PivotLayout.PivotFields 
 
 objNewSheet.Cells(intRow, 1).Value = objPF.Caption 
 
 intRow = intRow + 1 
 
 Next objPF 
 
End Sub

Properties

• Application
• Creator
• Parent
• PivotTable

See also

• Excel Object Model Reference

[!includeSupport and feedback]