Forum Discussion
Chart from dynamic array challenge
Hi (Excel 365 v2601 b19628.20132 Current Channel / Windows 11 25H2) Initial post edited (& cross posted here on Jan 29, 2026) after further investigations In B6 below an array that dynamically res...
Pivot & Chart Categories sorted as in the TOPN array:
- Don't unpivot the TOPN array
- Get its headers (Categories) instead
- Match them in the Source Table
- Filter the Source Table with the above array & the Year filter array
The PivotTable is the same (Sum of Values) + Show Values As: % of Row Total