Microsoft Excel - User Selectable Chart Topics (1 Chart - Many Stories)

Learn how to create a single chart that can tell multiple, different stories depending on a user's selection. This is a great way to save space on a data dashboard, or have a larger chart for easier reading that take sthe same space a many smaller charts (without sacrificing content.) File Download Link: https://www.bcti.com//wp-content/YT_D... 00:58 File Download Instructions 01:14 Understanding the project objectives 03:32 Creating the Category Dropdown List 04:13 Creating the Chart's Dynamic Data 05:34 Using the XMATCH Function 06:21 Using the CHOOSECOLS Function 07:43 Using the SORT Function 08:43 Dynamic Chart Titles 10:41 Creating the Dynamic Chart 12:01 Dynamic Sorting by User Selection 12:21 Building the Sort Selection Dropdown List 13:04 Updating the Sort Formula 16:37 Alternate User Input Ideas