Fix a Disabled Show Details Option in an Excel PivotChart
Question details
The user needs to use Show Details on a data point 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.
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.
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.
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.
In the PivotTable, right-click an item at the higher level and choose Expand/Collapse > Collapse Entire Field, if available.
Return to the PivotChart, right-click a data point representing the collapsed level, and select Show Details if the command is available.

Update Excel to the Latest Available Build
Update Excel if Show Details remains disabled after selecting a collapsed data point or the issue began after an Office update.
Inspect Source Records Through the PivotTable
Use the associated PivotTable if your goal is to extract the records behind a summarized value rather than expand a chart level.
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.

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.




