Symbols in Drop-down List and Charts
Charts and Visualization

Use of Symbols and Emojis in Excel Drop-down List and Excel Charts

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.

 

Task Status drop-down using the symbol
Task Status drop-down using the symbol

 

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.

Customer Sentiment drop-down list using Emojis
Customer Sentiment drop-down list using Emojis

 

3: Icon on the chart:

In this example, we have created a doughnut chart with emojis for Sales by Items.

 

Icons on the Doughnut chart
Icons on the Doughnut chart

Watch the step-by-step video tutorial:

Click here to download the practice file

PK
My Name is PK. I am founder of PK-AnExcelExpert.com. I am a Microsoft Certified Professional. I have more than 12 years of experience in Data Visualization, Excel Automation and dashboard creation. Excel is my passion and I like to do always something innovative in Excel and share it with other people.
https://www.pk-anexcelexpert.com