Excel links of the week – weekend without wire [Aug 26]
Last Saturday our internet connection at home went off. I called the road runner folks hoping to getting it back up, but no luck. We were told to wait till Monday evening before the service personnel could restore the connectivity. Thankfully, we didnt feel all that bored and could spend lot of time talking to […]
5 wonderful visualizations you must see [Aug 22]
Every week Pointy Haired Dilbert celebrates the art of chart making by sharing 5 of the most beautiful, innovative and effective infographic ideas from various sites. Click here to see the visualizations featured earlier. Pop, Soda or Coke? – Countywise terms used for sweetened carbonated water The pop-vs-soda map tells how marketers have been effective […]
Tiger Woods walks on water to please a fan – Awesome advertising
Look at the power of conversation. A fan posted on youtube showing an apparent glitch in Tiger Woods 08 video game that you can walk on water to hit a golf ball. What did Electronic Arts and Tiger Woods do? They post a response to that video advertising Tiger Woods 09 saying that “its not […]
Creating KPI Dashboards in Microsoft Excel [Part 1 of 6]
Creating KPI Dashboards in Microsoft Excel is a series of 6 posts by Robert. This 6 Part Tutorial on KPI Dashboards Teaches YOU: Creating a Scrollable List View in Dashboard Add Ability to Sort on Any KPI to the Dashboard Highlight KPIs Based on Percentile Add Microcharts to KPI Dashboards Compare 2 KPIs in the […]
It is show time baby! – better designer clocks to display time in your spreadsheets
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 […]
Excel Links of the week – What do you dream about? [Aug 19]
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 […]
Polar clock using donut chart [Excel Visualization fun]
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 […]