Dashboards are daily staple for some of us who need to report status to our bosses, present them in weekly meetings or generally CC half the world with what is up on our end.
There are several ways in which you can spice up the dashboard, one of the simple things to do is, to replace the standard Red, Green & Amber with Smileys 🙁 😐 🙂 Just follow these 3 simple steps add smileys to your dashboard.
-
First create a dashboard as usual
Of course, this is what you do everyday, so move on to next one
-
Add a column to display smiley symbols
The standard spreadsheet fonts like Arial, Verdana or Comic Sans (ahem) do not have smiley symbols as characters. You need to change the font to “Wingdings” (just select the cells, hit ctrl+shit+f to change the font), in this font, the characters JKL stand for
:) :| :(respectively.Thus, in order to show smileys in the new column you can write a simple if formula like
=IF(target < sales,"J",IF(target > sales,"L","K")) -
Finally, add conditional formatting to change the smiley color
Select the smiley cells, and launch conditional formatting dialog to specify conditions to change the color of cell contents. For eg. red when sales < target, blue when sales > target and gray otherwise as shown below:
So go ahead, wow someone with a smiley dashboard.
12 Responses to “Sachin Tendulkar ODI Stats – an Excel Info-graphic Poster”
A great tribute to one of the greatest batsmen's in Cricket history.
Thanks Chandoos!
A fantastic poster, Chandoo. I suspect most people would assume it was done in Adobe Illustrator.
Great work!
Daniel Ferry
excelhero.com/blog
[...] Visit his post to download the excel file: Sachin Tendulkar Statistics Excel Infographic Poster [...]
[...] Courtesy: Wikipedia.org >> Chandoo.org [...]
Please update the pingback url to http://www.newsilike.in/sachin-tendulkar-infographics/
Awesome man .....super work
[...] Wikipedia.org >> Chandoo.org ← Previous Next [...]
[...] Kummi in Blog, Dashboard, Excel, Infographic | No Comments Jan252012 Chandoo.org published an infographic poster created in Excel. As a big fan of Tendulkar, I really liked this [...]
[...] Via Tags: europe, football, european league, soccer, sports © 2012 Latest Infographics /* */ [...]
[...] Source [...]
[...] Link [...]
[…] Source […]