Beautiful Excel Charts: chart with emojis

This is a very simple way to create a beautiful chart in Microsoft Excel to visually display numbers with emojis and emoticons!

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 is licensed under Creative Commons License Attribution-NonCommercial 4.0 International.

About Aeternus Consulting

Aeternus Consulting is the premier provider of analyst-grade Excel training courses in Singapore. Our courses are conducted by trainers with 20 yrs of industry and teaching experience.

Related Link: Aeternus Consulting Excel Training Courses Singapore

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.

Related Link: Making Charts Beautiful with Microsoft Excel

excel courses in singapore
Advanced Excel Training Courses Classes Singapore: making beautiful charts

Leave a Reply

Your email address will not be published. Required fields are marked *

Contact Us

Drop us a message even when it’s late because the best ideas can come at night.

About Aeternus Singapore

aeternus consulting singapore logo
Aeternus Consulting is the premier consultancy firm for analyst-grade Microsoft Office training courses in Singapore. ACRA: T14LL0891K

Microsoft Office training solutions

corporate training course chair
We work with businesses and individuals who need effective Microsoft Office training solutions.

Analyst-Grade Training Courses

analytics with microsoft excel chart
Premium Training for Business Analysts, Data Analysts & Information Specialists in Singapore.

Our Services Include

Our Microsoft Office-centric services include:
* Full range of Microsoft Excel Training Courses in Singapore.
* Microsoft Office PowerPoint Training Courses.
* Consultancy in Excel, Access, VBA Application Development & PowerPoint Presentation Design Projects.
* Personal coaching & corporate bespoke Microsoft Office training sessions for employees.

Training Course List

Excel Basic, Intermediate, Advanced Levels
Excel PivotTables Inside Out
Data Management & Data Analysis in Excel
VBA Programming with Excel
Advanced VBA Programming with Excel
Essential Microsoft Excel for HR Professionals
Up to Speed with Microsoft PowerPoint
PowerPoint Design & Animation Ideas for Business
Microsoft SharePoint Training Workshop

Instagram (@aeternusconsulting)