Cool Visualizations of the Week [Aug 29] (1)
share
digg
by
Chandoo (3)
on
Pointy Haired Dilbert - Chandoo.org (3)
1 week, 1 day
ago
permalink
Once every week Pointy Haired Dilbert celebrates the art of chart making by sharing 4-5 of the best info-graphics featured in various web sites. Click here to see the charts featured earlier. How to does Love, Anger, Joy and other emotions look like? Have you ever wondered how your emotions look like? That is exactly what folks at Emotionally Vague have done. They have surveyed 250 people from 35 countries on what makes them emotional, ...
What they dont teach you in any school - Appreciation (2)
share
digg
by
Chandoo (3)
on
Pointy Haired Dilbert - Chandoo.org (3)
1 week, 2 days
ago
permalink
Back when I was doing MBA, one of the first courses we took was called MOC (Managerial Oral Communication). The idea of the course is simple. Each of the 60 students in class would give a 12 minute presentation on any topic of their choice to everyone. Then everyone has 8 minutes to provide suggestions, remarks to the presenter so that he/she can improve. It seemed like a great idea then. But most of the ...
Date with my sheet - 10 tips on using date, time in Excel (2)
share
digg
by
Chandoo (3)
on
Pointy Haired Dilbert - Chandoo.org (3)
1 week, 4 days
ago
permalink
Excel date time features are very handy and knowing them a little in depth can help you save a ton of time in your day to day spreadsheet chores. Let us prepare for your date with the sheet using these 10 handy tips. Before jumping on to the tips, it helps to know how excel represents the date and time. Microsoft Excel stores dates as sequential numbers … By default, January 1, 1900 is serial ...
Quickly process text using split() spreadsheet function in google docs (2)
share
digg
by
Chandoo (3)
on
Pointy Haired Dilbert - Chandoo.org (3)
1 week, 5 days
ago
permalink
Google docs spreadsheet app is going mainstream with each passing day. Recently they have introduced split() formula to divide text in to multiple cells using a user specified delimiter. The syntax for this function is =split(text value, delimeter), for eg. =split("pointy haired dilbert", " ") would result in 3 individual cells with “pointy”, “haired” and “dilbert” as values. Learn more. This is a very good replacement for excel import text functionality using which you can ...
5 wonderful visualizations you must see [Aug 22] (3)
share
digg
by
Chandoo (3)
on
Pointy Haired Dilbert - Chandoo.org (3)
2 weeks, 1 day
ago
permalink
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 and creating a habit in people. The blue colors are for pop, yellow for soda and red for coke. As ...
It is show time baby! - better designer clocks to display time in your spreadsheets (1)
share
digg
by
Chandoo (3)
on
Pointy Haired Dilbert - Chandoo.org (3)
2 weeks, 4 days
ago
permalink
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 all. It just emphasizes that what ever you give away will come back to you in better shape. So here ...
Is this Google adsense ad misleading? (1)
share
digg
by
Chandoo (3)
on
Pointy Haired Dilbert - Chandoo.org (3)
3 weeks, 1 day
ago
permalink
While surfing some of my regular reads on the google reader, I saw this feed ad from google adsense. The ad looks like a text ad with scroll bars. I have never seen scroll bars on text ads by google, so out of curiosity I clicked on the scrollbar and dang, it launched me to the advertisers page. On closer look I have realized that it is indeed an image ad with scroll bars in ...
Plot your data around the clock [Excel charting idea] | Pointy Haired Dilbert - Chandoo.org (1)
share
digg
by
Chandoo (3)
on
Pointy Haired Dilbert - Chandoo.org (3)
3 weeks, 2 days
ago
permalink
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 the carnage of a familiar metaphor and posted their awesome reviews here: Rock around the clock by ...
Simulating Dice throws - the correct way to do it in excel (1)
share
digg
by
Chandoo (3)
on
Pointy Haired Dilbert - Chandoo.org (3)
3 weeks, 2 days
ago
permalink
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 you have analysis tool pack installed like I do, then we can use randbetween(0,12) to do the same. In order ...
Beyond If and Sum, 15 really useful excel formulas for everyone (3)
share
digg
by
Chandoo (3)
on
Pointy Haired Dilbert - Chandoo.org (3)
3 weeks, 3 days
ago
permalink
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 - to UPPER, lower, Proper Boss wants a report of top 100 customers, thankfully you have the data, but ...
5 Infographics that can WOW you [Aug 7] (2)
share
digg
by
Chandoo (3)
on
Pointy Haired Dilbert - Chandoo.org (3)
1 month
ago
permalink
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 Onion Maps - 3d outlines of buildings colored and mashed up with google maps Onion maps is the new kid on ...
15 Fun things to do with Microsoft Excel (17)
share
digg
by
Chandoo (3)
on
Pointy Haired Dilbert - Chandoo.org (3)
1 month
ago
permalink
Who said Excel takes lot of time / steps do something? Here is a list of 15 incredibly fun things you can do to your spreadsheets and each takes no more than 5 seconds to do. Happy Friday 1. Change the shape / color of cell comments Just select the cell comment, go to draw menu in bottom left corner of the screen, and choose change auto shape option, select a 32 pointed star or ...
Cool infographics around the web - [july 31] (1)
share
digg
by
Chandoo (3)
on
Pointy Haired Dilbert - Chandoo.org (3)
1 month
ago
permalink
Time for another round of cool charting / info-graphic ideas around the web. Most Popular Baby Names - all the way from 1880 Nametrends is a cool website totally dedicated to analyzing and showing baby name trends. They have pretty interesting stuff like, how baby names ending with -lie (charlie, willie, ellie etc.) fared from 1880. Go ahead, see the neat stuff at nametrends. [via kottke] Flare toolkit for visualizing in Flash Flare is a ...
Want to Feed RSS to your Excel Sheet? Read this! (3)
share
digg
by
Chandoo (3)
on
Pointy Haired Dilbert - Chandoo.org (3)
1 month, 1 week
ago
permalink
RSS feeds are everywhere. So much that you cannot avoid them in your data processing, analytics or day to day spreadsheet needs. If you can get the RSS feeds to excel sheet you can do pretty interesting things with it, like: Prepare a sheet to watch deals on Amazon, Craigslist, Deals2buy and other favorite sites Watch news, alerts on your company / brand / blog using technorati, google news etc. So much more, just use ...
Shuffle a list of numbers / items in excel spreadsheet (1)
share
digg
by
Chandoo (3)
on
Pointy Haired Dilbert - Chandoo.org (3)
1 month, 1 week
ago
permalink
Here is a quick Monday tip for data junkies. If you want to shuffle a list of numbers or cells in excel in random order you can do that with “data > sort” menu option of excel. First insert a column next to the list you want to shuffle and enter random numbers in each cell in using =rand(). See below: Now select the entire list and sort it by the new column with random ...
Do you know you can mute conversations in Gmail? (2)
share
digg
by
Chandoo (3)
on
Pointy Haired Dilbert - Chandoo.org (3)
1 month, 2 weeks
ago
permalink
Mute conversations in Gmail Do you know that you can mute conversations in gmail if you are do not want to see that lengthy thread on single subjected that people wont give up. Just select the mail / conversation you want to mute Click on “More actions” and select “mute” Enjoy the bliss If you want search for muted conversations use “is:muted” search operator. Read up more on muting conversations at Gmail Help.
Become a Dashboard Ninja with Bullet Graphs (2)
share
digg
by
Chandoo (3)
on
Pointy Haired Dilbert - Chandoo.org (3)
1 month, 2 weeks
ago
permalink
Bullet graphs provide an effective way to dashboard target vs. actual performance data, the bread and butter of corporate analytics. Howmuchever effective they are, the sad truth is there is no one easy way to do them in excel. I have prepared a short tutorial that can make you a dashboard ninja without writing extensive formulas or installing unknown add-ins. So get out your shinobigatana and join me in a fresh excel sheet arena. Before ...
Awesome folks at flickr introduce instant zoom for photos (1)
share
digg
Improve your in-cell charts with colors and negative values (2)
share
digg
by
Chandoo (3)
on
Pointy Haired Dilbert - Chandoo.org (3)
1 month, 3 weeks
ago
permalink
In response to Making Incell charts better article, reader Tony mailed me an excel sheet in which he has modified the charts to display colors and negative values. This is pretty cool. Take a look at the chart below: MS Excel Incell charts with colors and negative values The trick lies in displaying the charts in 2 rows, one for positive values and another for negative values and then coloring positive row with green and ...
Bingo / Housie Ticket Generator in Excel (1)
share
digg
by
Chandoo (3)
on
Pointy Haired Dilbert - Chandoo.org (3)
1 month, 3 weeks
ago
permalink
I am fascinated by board games. They provide immense fun, anyone can enjoy them, they are unpredictable and best of all they are great value for money. That is why whenever I get sometime I experiment with simulating games to know them better [read Why Monopoly board game is not as random as it appears]. So, out of curiosity I have created an excel sheet that can generate bingo / housie (housey) tickets - 24 ...
