Add Expand and Collapse Controls to Excel PivotChart Legend Fields
Question details
The user wants to expand and collapse country and city fields displayed in an Excel PivotChart legend.

- Product
- Microsoft Excel PivotChart
- Device & OS
- not provided
- Scenario
- A PivotChart displays a geographic hierarchy in the Legend (Series) area rather than on the category axis.
- Observed behavior
- Expand and collapse controls are available for category-axis fields, but not for fields in the PivotChart legend.
Select the PivotChart and open the PivotChart Fields pane to check whether Country and City are in Legend (Series). Locate the associated PivotTable if you want to try controlling the hierarchy there.
Expand or collapse the hierarchy in the associated PivotTable
Try changing the country and city detail in the PivotTable when you need to adjust the chart without legend buttons.
Excel does not provide expand and collapse buttons directly in the PivotChart Legend (Series) area. Changes made in the associated PivotTable may affect the chart, depending on the field layout and data source.
Select the PivotChart and locate the PivotTable connected to it in the workbook.
Open the PivotTable Fields pane and check that Country and City are nested in the Rows or Columns area, with Country above City.
In the PivotTable, right-click a country label and choose Expand/Collapse, then select Expand or Collapse. You can also use the plus or minus button beside the label if it is visible.
Return to the PivotChart and verify whether its series display changed as intended. Adjusting the PivotTable layout may also change how the chart is organized.

Request legend expand and collapse buttons in Excel
Use Excel feedback to suggest native controls for fields in the Legend (Series) area.
Work with PivotTables in WPS Spreadsheet
WPS Office is a free, lightweight, easy-to-use Microsoft Office alternative with a familiar interface. Open compatible Excel workbooks in WPS Spreadsheet to make migration easier, although it does not add the missing controls to Microsoft Excel.

Frequently Asked Questions
Can I add expand and collapse buttons directly to an Excel PivotChart legend?
No. Excel does not currently support those buttons for fields in the Legend (Series) area. You can submit a feature suggestion through File > Feedback.
Can the associated PivotTable control the chart's detail level?
It may, depending on the field layout and data source. In the associated PivotTable, right-click a hierarchy item and choose Expand/Collapse, then check the PivotChart for the result.
Are PivotChart field buttons the same as expand and collapse buttons?
No. Field buttons identify or filter PivotChart fields; they do not add expand and collapse controls to the legend.
How do I suggest this feature to Microsoft?
In Excel, open File > Feedback, choose the option to suggest a feature, and describe the controls you need for Legend (Series) fields.




