In this article, we have explained how to add the symbols and emojis to the Excel Drop-down list and Charts. To get the symbols you can press Windows+Period(.) shortcut key together.
We have explained it through three examples
1: Task Status drop-down using the symbol:
In this example, we have taken the “â” and “â” symbols in the data Validation drop-down list. Then we have put the conditional formatting to highlight “â” in green font and “â” in red color.
2: Customer Sentiment drop-down list using Emojis:
In this example, we have taken đ, đ and âšī¸ in the data Validation drop-down list. Then we have put the conditional formatting to highlight đ in green font color, đ in yellow font color, and âšī¸ in red font color.
3: Icon on the chart:
In this example, we have created a doughnut chart with emojis for Sales by Items.
