Pivot Table Issues

Add Expand and Collapse Controls to Excel PivotChart Legend Fields

Huma Ashraf ChHuma Ashraf Ch Nov 22, 2026 868 views

Question details

The user wants to expand and collapse country and city fields displayed in an Excel PivotChart legend.

Add Expand and Collapse Controls to Excel PivotChart Legend Fields
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.
Before you start

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.

Solution 1Recommended

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.

1
Find the PivotTable

Select the PivotChart and locate the PivotTable connected to it in the workbook.

2
Check the field hierarchy

Open the PivotTable Fields pane and check that Country and City are nested in the Rows or Columns area, with Country above City.

3
Change the detail level

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.

4
Check the PivotChart

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.

Expand or collapse the hierarchy in the associated PivotTable
Legend controls remain unavailable: This workaround does not add expand and collapse buttons to the PivotChart legend.
Free Microsoft Office alternative

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.

Work with spreadsheet data and PivotTables in WPS SpreadsheetOpen and edit Microsoft Excel formats including XLSX and XLSUse a familiar spreadsheet interface for an easier transitionGet a free, lightweight office suite
microsoft office alternative - wps office

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.