One worksheet · a clearer chart

Keep the data. Choose the controls.

Trace the real report cells, simplify the chart, then edit the same workbook yourself.

Teaching · read-only · Report!A1

Step 1 / 6Trace a mark to the actual report

Inspect

The chart reads calculated worksheet cells, excluding the grand margins. Complete-source members remain; empty averages are gaps and measured zero stays zero. Teaching is read-only; switch to Your turn to edit.

Chart and source!I61 · (blank)
No formula applied

Preparing the range-bound chart worksheet…

Correct source/control cells or explicitly repair edited helpers. Previous valid report remains until correction.

Chart settings on the actual worksheetTitle Type Value labelsLegendEnable configured field controlsfilter field controlscategory field controlsvalue field controlsseries field controls

Report membership remains available when chart controls are hiddenregion membership status membership row field column field Summary

Hiding field controls changes presentation, not membership. The native report uses a real Included page filter whose source formulas capture the saved Region/Status criteria. Its field-control group corresponds to Included; the browser’s membership controls edit those actual worksheet criteria. Complete-source members remain visible, including zero Sum/Count and undefined Average. This lab accepts up to 50 records, 50 row members and 12 column members; it does not replace the existing ranked/mixed-unit PivotChart workflow. Current worksheet copies contain cells/formulas/settings; the native copy also contains the chart. Desktop Excel field-button interaction, rendering and refresh/edit/save remain unverified.

Microsoft: show/hide all PivotChart field buttons