My polar clock using donut charts in excel started a conversation and readers have been awesome enough to download the excel and create their own clocks to show time. Even though the idea of this blog is share the little that I know with you, it is amazing how much I have learned from you [...]

The other day my wife told me that we dream about a total of 6 years in our life, an average of 2 hours for everyday you sleep. [Source: wikipedia on dreams]. That is almost as much time as you would work in 30 years (30*50*40/24/365, assuming you work 40 hours a week for 50 [...]

Smashing Magazine is one of daily hangouts for new design ideas, inspiration and ogle fun. When they featured Pixel Breaker’s Polar clock last Friday on Top 10 creative ways to display time, I knew this could be an interesting visualization to do in excel. So I have created a donut chart in excel that can [...]

If your reports include hourly distribution of data like,

Customer footfalls in your store
Page views of your site
Customer service calls to your toll free numbers

here is an interesting charting idea to show the data around the clock (literally)

Update: Visualization pros Jon Peltier and Jorge Camoes took a critical look at this, nearly fainted at [...]

If you ever had to simulate random outcomes in excel sheet, you might have already heard of about the spreadsheet function rand(), this little function generates a random fraction between 0 and 1 whenever you use it. So I usually write =round(rand()*12,0)int(rand()*12)+1 if I need a random number between 0 to 12. Of course, if [...]

Excel formulas can always be very handy, especially when you are stuck with data and need to get something done fast. But how well do you know the spreadsheet formulas?
Discover these 15 extremely powerful excel formulas and save a ton of time next time you open that spreadsheet.

1. Change the case of cell contents - [...]

My Olympic medals by country year visualization in excel is received well by readers. I got few interesting emails on it.
Robert from Germany shares an interesting approach at doing this, by doing a heat map of the medal counts on an outline world map. This is very impressive and involves flood filling countries with a [...]