Market Segmentation Charts using Conditional Formatting
Trust Peltier to come up with solutions for even the most impossible looking charts. Today he shares a marimekko chart tutorial. I couldn’t sit still after seeing his post. So here comes market segmentation charts or marimekko charts using,
The new Mac vs. PC web ad by Apple is really cool
Did you checkout the new web based Mac vs. PC ads Apple is running on the CNN.com? They are totally cool. why? because, in that ad, the PC guy walks from one ad-block to another creating wow user experience for whoever seeing the ad. Here is a small animation I have created out of it […]
Sorting Text in Excel using Formulas
Sorting text is such a day to day activity that it always surprises me why Excel hasn’t provided a simple spreadsheet formula for doing it. Of course you can use the sorting menu command (menu > data > sort) but this requires manual steps (or VBA). Most of the times we get raw textual data […]
How to WOW your customers with tracking – Dominos pizza example
Saturday we were in no mood to cook, we were feeling all tired up after roaming in Seattle. So we ordered pizza from dominos pizza website. The ordering process is simple and straight forward. But what awed me most is the pizza tracker. Once you place the order they show you this pizza tracker: That […]
Microsoft says ‘I am PC’ and it is brilliant
The new Microsoft “Hi, I am PC” ads are supercool. Apple has been making fun of PC (and PC users) for while with the “I am PC, I am Mac” ads and the response from MS advertising team is nothing short of brilliant. With these simple & funny ads, they have changed the focus from […]
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 […]
5 Infographics that can WOW you [Aug 7]
Time for another week of ogling at cool visualizations. What a week it has been for the chart makers 😉 Super cool visualization of 2008 Box office collection This is an area chart modified to indicate how a movie has performed everyweek, thus the movie markers go down (except for dark knight) after 1-2 weeks […]