Beautiful Excel Charts: chart with emojis


Pretty much anyone can put some data into Excel and create a chart. But not everyone can create a chart that is beautiful, easy to understand and tells a compelling story! Being able to visualize data tell a great narrative is key to turning it into information that can be used to drive better decision making.

This is a very simple way to create a beautiful chart in Microsoft Excel to visually display numbers with emojis and emoticons! The key idea is to use the Excel Function REPT to create repeating emojis. The Microsoft Excel REPT function returns a repeated text value a specified number of times.

The syntax for the REPT function in Microsoft Excel is:

REPT( text, number )

chart with cute emojis
Quick and easy way to create a chart in Microsoft Excel!

Step 1: Create the data set directly on an empty worksheet.

Step 2: Insert an emoticon in cell B13 by pressing the windows keyboard shortcut: Windows key and the period button.

inserting emojis using windows keyboard shortcut
Press Windows key + Full stop key to display the Emojis dialog window.

Step 3: Insert an Excel formula in Cell D3 =REPT($B$13,ROUND(C3/100000000,0))

Step 4: Autofill this formula in cell D3 to D13 and you are all done!

There are many possibilities to this basic Excel chart design. You can vary the font colours easily for a different look or even change the icons by using true type wingding fonts instead of emojis. By using icons in a chart it can make difficult numbers easier to digest for an audience.

I have provided the actual Excel file for you to download here. This file

by Aeternus Consulting is licensed under Creative Commons Licence Attribution-NonCommercial 4.0 International.

Aeternus Consulting offers an excellent workshop Storytelling with Data Visualization using Beautiful Excel Charts. This workshop is aimed at students visualizing thesis data, managers and analysts needing to communicate in a data-driven way and leaders informing their board to drive actions.

Derek Leong

Derek Leong

Derek has over a decade of experience developing VBA applications in Microsoft Access and Microsoft Excel. He also conducts VBA programming classes occasionally.

Share this post

Share on facebook
Share on google
Share on twitter
Share on linkedin
Share on pinterest
Share on print
Share on email

Let's have a chat


We are Aeternus Consulting.

We like to put our hands into a lot of things. We consult, develop applications, design presentations and teach.