Red vs. Blue - 35 Cool Visualizations on 2008 US Presidential Election (1)
share
digg
by
Chandoo (16)
on
Pointy Haired Dilbert - Chandoo.org (16)
4 days, 20 hours
ago
permalink
With 2008 US Presidential elections around the corner everyone is busy including chart makers. There are hundreds of excellent visualizations on the presidential election campaign, speeches, issues, predictions that keeping track of what is best can be a tough task. We at PHD have compiled a list of 35 totally awesome visualizations on the 2008 election. Do check these to get more insights in to this election. The visualizations are grouped in to these categories: ...
Deal or No Deal - Download and Play the Popular TV Game Show in Excel (2)
share
digg
by
Chandoo (16)
on
Pointy Haired Dilbert - Chandoo.org (16)
1 week, 1 day
ago
permalink
Ever since we moved to Seattle we have been watching TV game show - Deal or No Deal (for lack of better things to do in the hotel) The game provides an interesting look at human nature and risk taking abilities. People who wouldn’t risk their retirement savings or jobs would go to these game shows and take risks to win all or nothing. It is fascinating to see how one makes judgment to accept ...
Display decimals only when the number is less than 1 [Excel number formatting tip] (2)
share
digg
by
Chandoo (16)
on
Pointy Haired Dilbert - Chandoo.org (16)
1 week, 2 days
ago
permalink
Here is a quick excel number formatting tip. If you ever want to format numbers in such a way that it shows decimal values only if the number is less than 1 you can use conditional custom cell formatting (do not confuse with conditional formatting). Here is an example: In such cases you can use conditions in custom cell formatting. First select the numbers you want to format, hit CTRL+1 (or right mouse click > ...
Simple Todo List application using Excel - Download and become productive (1)
share
digg
by
Chandoo (16)
on
Pointy Haired Dilbert - Chandoo.org (16)
1 week, 3 days
ago
permalink
After seeing Andrew’s simple excel based check-list I got this idea of preparing a simple To-Do list application using excel. Since most of us use Excel on day to day basis, why not use it as a productivity application as well by keeping track of all the things we must do (TO DO List). When we have finished a task, we can mark it as “Done” in the sheet and it will be removed. See ...
How to WOW your customers with tracking - Dominos pizza example (1)
share
digg
by
Chandoo (16)
on
Pointy Haired Dilbert - Chandoo.org (16)
1 week, 5 days
ago
permalink
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 is right, they tell you “Jeffery began custom making your order”, not “your pizza is being prepared” or something else. ...
Visualizing Sex & Love - 10 Infographics You Must See (1)
share
digg
by
Chandoo (16)
on
Pointy Haired Dilbert - Chandoo.org (16)
2 weeks, 1 day
ago
permalink
Dont think of me as a perverted spreadsheet user, I like visualizations in any form or shape. There is so much data even about human relationships like love and sex. This article shows 10 of the most visually beautiful and insightful of the infographics on sex and love. Click on the titles above images to see the detailed site. The links are mostly safe for work, so enjoy the Friday 1. Charting the Dating Data ...
Microsoft says ‘I am PC’ and it is brilliant (1)
share
digg
by
Chandoo (16)
on
Pointy Haired Dilbert - Chandoo.org (16)
3 weeks, 1 day
ago
permalink
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 software to users and boy they have done it well. See the ad below: (see it on youtube) It is ...
Power Outage & 99 Excel Tips to keep you Busy (1)
share
digg
by
Chandoo (16)
on
Pointy Haired Dilbert - Chandoo.org (16)
3 weeks, 4 days
ago
permalink
We have a major power outage in Ohio due to a wind storm on Sunday. AEP, Our electric provider says that power would be restored to my area by this Friday midnight, that is almost 6 days without power. I will not be able to blog regularly during this period. So here is a list of 99 excel tips that are posted here in the past. Browse them and enjoy 3 Impressive Excel Charts you ...
Tracking your stock portfolio using Google Docs (1)
share
digg
by
Chandoo (16)
on
Pointy Haired Dilbert - Chandoo.org (16)
4 weeks, 1 day
ago
permalink
By integrating services like Google Finance, Search in to spreadsheet functions, google docs has paved the way for endless possibilities. Google spreadsheet function GoogleFinance() can be used to build stock portfolio tracker sheet that can fetch historical stock quotes to tell how your money is doing. Click here to see the stock portfolio tracker sheet on Google docs. Here is how you can create a simple stock / mutual fund / asset tracker application using ...
What is the best micro charting tool for Excel? - 7 Alternatives Reviewed | Pointy Haired Dilbert - Chandoo.org (2)
share
digg
by
Chandoo (16)
on
Pointy Haired Dilbert - Chandoo.org (16)
1 month
ago
permalink
With each passing day the amount of information contained in a single spreadsheet, slide, document is growing. Thanks to demanding bosses, clients and colleagues, we are now supposed to provide all the relevant information in as much less space as possible. This is where micro charting or light weight data exploration has become a rage. The idea of shrinking a chart to fit in side a cell has been catching up with corporates and individuals ...
Splitting text in excel using formulas (1)
share
digg
by
Chandoo (16)
on
Pointy Haired Dilbert - Chandoo.org (16)
1 month
ago
permalink
Often when you are processing text using excel it is important to split the text in to multiple parts based on a delimiter. For eg. you may want to divide this|needs|to|be|split in to five parts this needs to be split. There is a simple way to do this in excel, using “import text” option. But this is not always preferable, especially if you need to split text as part of a large process, then you ...
6 excel charts you must never use | Pointy Haired Dilbert - Chandoo.org (2)
share
digg
by
Chandoo (16)
on
Pointy Haired Dilbert - Chandoo.org (16)
1 month, 1 week
ago
permalink
Often it is easy to get carried away with a tools features. Excel is no exception. But here is a list of grotesque charts that you should never make, not even on your last day at work. 1. Leave the radar charts for Spidermen why? You can hardly conclude anything by looking at them They need lot of tweaking to make sense Visually revolting, even with perfect data points 2. Dont show, just eat your ...
Cool Visualizations of the Week [Aug 29] (1)
share
digg
by
Chandoo (16)
on
Pointy Haired Dilbert - Chandoo.org (16)
1 month, 1 week
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 (16)
on
Pointy Haired Dilbert - Chandoo.org (16)
1 month, 2 weeks
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 (16)
on
Pointy Haired Dilbert - Chandoo.org (16)
1 month, 2 weeks
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 (16)
on
Pointy Haired Dilbert - Chandoo.org (16)
1 month, 2 weeks
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 (16)
on
Pointy Haired Dilbert - Chandoo.org (16)
1 month, 2 weeks
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 (16)
on
Pointy Haired Dilbert - Chandoo.org (16)
1 month, 3 weeks
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 (16)
on
Pointy Haired Dilbert - Chandoo.org (16)
1 month, 3 weeks
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 (16)
on
Pointy Haired Dilbert - Chandoo.org (16)
1 month, 4 weeks
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 ...
