visualization Category 
Doing the NY times Olympic medals by country year visualization in excel
on 6 Aug, 2008 in Analytics, Excel Tips, Featured, cool infographics, ideas, visualization | 22 Comments
When I saw the Olympic medals won by each country by year infographic on nytimes my jaw almost dropped, go ahead see it and come back, I am sure you will love it too.
It is one of the coolest visualizations I have seen in the recent past and I see infographics all the time, [...]
Vizooalization: 5 things I have learned about visualization at the zoo
on 5 Aug, 2008 in ideas, visualization | 4 Comments
On Saturday we went to Columbus zoo, apart from enjoying the lions, penguins, birds, I have also learned 5 simple yet effective lessons in visualization.
1. Design your charts for kids - assume your audience knew bare minimum and curious
Above shown is a typical Zoo-mate info dashboard that you can see next to any animal [...]
Read More >>Cool infographics around the web - [july 31]
on 31 Jul, 2008 in cool infographics, ideas, visualization | 0 Comments
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 [...]
Read More >>Excel Links of the week
on 29 Jul, 2008 in Excel Tips, ideas, visualization | 1 Comment
Here is a quick round up of excel posts from few of the awe some blogs around the web:
At PTS Blog, Jon provides excellent tutorial on adding target lines to your bar charts to show target vs. actual performance. He has several other tweaks for your category axis as well, just read the other posts [...]
Cool infographics around the web
on 24 Jul, 2008 in cool infographics, ideas, visualization | 0 Comments
Starting this week I will post cool infographics from around the web, 4-5 of them a week to inspire , to give more ideas on presenting information and to provide some eye candy for awesome readers @ Pointy Haired Dilbert.
Go ahead, click through these awesome graphics:
California Walkability Score Heat Map
Lee Byron took the [...]
Read More >>Become a Dashboard Ninja with Bullet Graphs
on 21 Jul, 2008 in Analytics, Excel Tips, Featured, hacks, ideas, technology, visualization | 6 Comments
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 [...]
Improve your in-cell charts with colors and negative values
on 17 Jul, 2008 in Excel Tips, hacks, ideas, technology, visualization | 11 Comments
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:
The trick lies in displaying the charts in 2 rows, one for positive values and another for [...]
Read More >>
- Pankaj Verma: Know what - I wonder, perplexed and bewildered to think that...
- Bhars: Wonderful calendar!! Thanks a lot!...
- Stružák: Hi, would you mind publishing a calender template with weeks...
- Ketan: In any cell after writting the formula and bfore pressing th...
- Ketan: You may use any shape or text box too and link the data of d...
More Comments