Excel Dynamic Arrays & Charts: Spilled Arrays in Charts with Defined Names (Excel Magic Trick 1527)
Download Excel File: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/EMT1526-1527.xlsx
This video discusses how to get Spilled Arrays into Charts. Direct Spilled Arrays don’t seem to work, but we can use the Old Fashion Method and use Defined Names to point to our Spilled Arrays..
Entire page with all Excel Files for All Videos: http://people.highline.edu/mgirvin/excelisfun.htm Excel Dynamic Arrays: Fully Dynamic Cross Tabulated Reports? Unbelievable! EMT 1520 : https://www.youtube.com/watch?v=ZXn0D4Ch7zg