Microsoft Excel - Custom Chart Label Ranges (with User Switching)
Learn how to create custom number labels for charts that dynamically adjust depending on the values. Also, see how to use symbols (emojis) as chart labels to indicate status, letting the user select the indicator dynamically
File Download Link:
https://www.bcti.com//wp-content/YT_D...
00:42 Overview of Video Objectives
01:23 Understanding Custom Number Formatting Codes
04:42 Download File Information
05:32 Formatting the Upper Range of Values
07:42 Assign Custom Labels to a Chart
08:15 Formatting the Middle Range of Values
10:11 Formatting the Lower Range of Values
11:03 Combining the Formatting Logic
12:47 Formatting Long, Confusing Formulas
13:41 Using Emojis as Labels
15:04 Using Status Indicators as Chart Labels
15:47 User-Switching Control for Chart Labels
18:10 Hiding Custom Label Formulas - BEWARE
18:41 Project Summary