Switching Tables and Charts Using a Drop List

In this tutorial I create multiple charts from a source table and then create a Drop Down List that allows me to switch between the different charts and the Source table. This amazing technique can be used in creating a dynamic Dashboard.
You can download the start file and follow along by clicking on the link:
https://www.amazon.ca/clouddrive/shar...

• #education
• #column_charts
• #dashboard
• #drop_list
• #data_validation
• #vlookup
• #define_name
• #indirect_function
• #chart_formatting
• #excel
• #officeinstructor