Pivot Table Issues

Fix a Disabled Show Details Option in an Excel PivotChart

Natalie TaylorNatalie Taylor Nov 14, 2026 868 views

Question details

The user needs to use Show Details on a data point in an Excel PivotChart.

Fix a Disabled Show Details Option in an Excel PivotChart
Product
Microsoft Excel for Microsoft 365
Device & OS
not provided
Scenario
After an Office update, the user selects a PivotChart data point to view more detail.
Observed behavior
Show Details is disabled in the PivotChart even though Enable Show Details is selected in the associated PivotTable.
Before you start

Select the PivotChart and locate its associated PivotTable. Check whether the chart has multiple levels of row or column detail that can be collapsed and expanded.

Solution 1Recommended

Collapse a Detail Level Before Using Show Details

Use this method when the PivotChart has multiple levels of detail and Show Details is unavailable for the selected data point.

Show Details may be available only when the selected data point represents a collapsed level. Expanding a chart level is different from extracting the source records behind a PivotTable value.

1
Check the field levels

Select the associated PivotTable and review the Rows and Columns areas in the PivotTable Fields pane. If appropriate, add another field to create a lower detail level.

2
Collapse a level

In the PivotTable, right-click an item at the higher level and choose Expand/Collapse > Collapse Entire Field, if available.

3
Show the detail

Return to the PivotChart, right-click a data point representing the collapsed level, and select Show Details if the command is available.

Collapse a Detail Level Before Using Show Details
Free Microsoft Office alternative

Work With PivotTables in WPS Spreadsheets

WPS Office is a free, lightweight alternative with a familiar spreadsheet interface. Open compatible Excel files to continue working in WPS, making it easier to move between office suites. It does not repair Excel's Show Details command.

Create and analyze PivotTables in WPS SpreadsheetsOpen and edit compatible Microsoft Excel .xlsx filesUse a familiar interface when moving from Microsoft OfficeWork with a free, lightweight office suite
microsoft office alternative - wps office

Frequently Asked Questions

Why is Show Details disabled in my PivotChart?

The selected data point may not represent a collapsed detail level. Collapse a level in the associated PivotTable, then right-click the corresponding chart data point and check Show Details again.

Does Enable Show Details guarantee the chart command will be available?

No. The PivotTable setting permits supported detail operations, but the chart command can still depend on the selected data point and whether a lower level is collapsed.

How can I see the records behind a PivotTable value?

Double-click a summarized value cell in the associated PivotTable, or right-click it and select Show Details. Excel creates a new worksheet with the records when the data source and configuration support it.

How do I check for an Excel update?

In Excel, go to File > Account > Update Options > Update Now, if that option is available. If your organization manages Office updates, contact your administrator.