Link Chart to Data in Dynamic Spilled Array Formulas in Excel
Link Chart to Data in Dynamic Spilled Array Formula
Steps:
1. Create Dynamic Array Formulas for Category and Numbers
2. Use Name Manager to reference cells with formulas
*Include $’s and #
3. Use Current Data to create initial chart
4. Replace Source Data with named range formula
*Must keep sheet name
0:00 Intro/Steps
0:15 Create Dynamic Formulas
0:31 Use Name Manager
1:15 Create Initial Chart
1:29 Replace Source Data with Named Ranges
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Please checkout my book, Power Query M Language Basics Kindle Edition
https://www.amazon.com/dp/B0DM73H3RV
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~