✉️Please Like 😍 and Subscribe 👍 My Channel✉️
Excel has the 'Table Function' which is very powerful and very easy to use even for the Excel Beginner.
But, what if you need the dynamic chart from the data of Merged cell or the range contains the blank data?
Let's look at how you can create the dynamic chart by INDEX dynamic range.

1:30 Basic of INDEX function
3:17 INDEX function example (reference type, array type)
7:11 INDEX dynamic range
11:16 How to set the dynamic range referring to the entire sheet.
13:27 Dynamic Chart - Using Table function
15:30 Dynamic Chart - Using Dynamic Range
21:00 Dynamic Chart - Set the Chart Preferences

⬛ Free Example File and E-book is Available !
http://oppadu.com/엑셀-무료-강의/엑셀-index-함...

⬛Oppadu Excel Official Homepage
http://www.oppadu.com

⬛Oppadu Excel Official Facebook & Instagram (HighLight Video is Available!)
http://bit.ly/Oppadu_FaceBook
http://bit.ly/Oppadu_Instagram