All The Icons For The Wingdings and Webdings Fonts
Here is a list of all the icons (by character) for:
- Webdings font
- Wingdings font
- Wingdings 2 font
- Wingdings 3 font
You can click on the below summary to see all your icon options a little more clearly. Enjoy!
Why are Icon Fonts Important?
I love using Icon Fonts because they can add great visualizations to your data and dashboards. You might be thinking....
"Chris, doesn't Excel already have pre-built conditional formats that do that for you?"
Well, yes you are exactly right. BUT, while the conditional formats can be great, there are some instances where they really can be limiting and look unprofessional.
Let's look at this simple Balanced Scorecard example (click the graphic to enlarge it).
In the scorecard examples above, I used the built-in Excel icon conditional formatting and then created a similar scorecard using the Webdings font (character "n") and some conditional formatting to change the color.
The first thing you might notice is when you enlarge this image, the conditionally formatted circles are blurry (this is due to me increasing the font size). This looks extremely unprofessional and might distract/irratate your audience.
The second thing that you might notice is with icon fonts I have the freedom to make the stoplights any color I want! This can make your tables match your company's specific branding color palette, which will make it look amazing in presentations (and score you brownie points with your marketing department).
Let's take a look at a second example.
In this table, I use Webdings (characters "p" and "q") to add an even clearer visualization to the data. How much more appealing is that!
Free Printable PDF For Your Office or Cubicle!
There are endless possibilities when you break out of the standardized conditional formats and incorporate icons into your data and charts. I personally use a cheat sheet I created some time ago and have it printed and hanging on my cubicle wall next to my computer. If you want a free PDF copy of my cheat sheet, you can sign up for my free newsletter and instantly gain access to my icon cheat sheet (shown at the beginning of this article) and all the other example files used in my blog post. Plus you'll get my best tips & hacks to improve as an analyst, emailed to you a couple of times a month (none of them are posted on this website, so it's completely new content).
Just click the green download button below and you can quickly sign up and get your printable cheat sheet!
How Do You Use Icon Fonts?
I quickly touched on a couple ways I use icon fonts to make my data look more professional and understandable. I would love for you to leave a comment below and describe how you are planning on using icon fonts in your next project. Your experience or thoughts will help the whole TSG community (including myself) get ideas on how to improve our work. Thanks for stopping by!
Chris "Macro" Newman