INDEX & MATCH Functions for Changing between 12 Charts dynamically

Charts are great for visualizing data. But having too many charts in a single worksheet may be confusing. In this tutorial I show you how to create 12 charts and be able to switch charts by selecting different options from a drop list. I'll be using INDEX & MATCH functions to do that