Treemap in Excel – Coming Soon

Its been a few days since I posted. In case you were wondering what I was up to - yours truly was busy coding a program to create treemaps in Excel. Treemaps are interesting creatures. You can pack a few thousand data points in a single treemap and utilize just about the same space as any of the traditional charts. The term 'treemap', as we see it being used nowadays, actually refers to the inward ...

Continue Reading

Treemap in Excel - Coming Soon

Chart Table – When Chart meets Table

Posted on 15 September 2009

Chart Table - When Chart meets Table
Chart table - as the name suggests - is a beautiful fusion of a chart and a table giving rise to a visually appealing yet information rich presentation of data. Not that the concept itself is anything new - experts have openly and vociferously championed the cause of the chart table, its various facets have been discussed at length in numerous forums and the latest versions of excel come equipped with tools that further aid their creation (namely sparklines). However ...
Continue Reading

Comments (6)

How to Choose a Chart

Posted on 03 July 2009

How to Choose a Chart
How to choose a chart? Which chart would best fit the data set that I have? How do I choose the better chart type from Excel? Finding the right type of chart for the data set that you have can be a bit of a challenge. Given a set of seemingly equivalent alternatives, picking one chart over the other can turn out to be quite an interesting exercise. The chart chooser diagram can help you make a choice in situations ...
Continue Reading

Comments (8)

Chartjunk

Posted on 29 June 2009

Chartjunk
Chartjunk, a term first coined by Edward Tufte, refers to all those elements in a chart that add no further value. Chartjunk comes in many shapes and size - redundant labels, unnecessary gridlines, over-the-top use of colors and everything that a 'creative' mind can think of. However what should be kept in mind is that this term also has a strong contextual meaning. An element that may appear as chartjunk in one graph may serve a useful function in another ...
Continue Reading

Comments (6)

Where did my money go ?

Posted on 11 June 2009

Where did my money go ?
Flowing data had this posted a few months back showing various infographics which chart out the financial crisis and the events related to it. There even an interesting clip that you can watch. Interestingly the article also carries the impressive NY Times graphic on how this bear market compares to ...
Continue Reading

Comments     

Make Charts in Excel Using Symbols

Posted on 21 May 2009

Make Charts in Excel Using Symbols
You can use Excel to make charts using symbols and display unconventional characters. Here's a list of symbols that can be used for making charts in excel. You can generate these symbols in Excel by formatting normal alpha-numeric characters with in-built or custom fonts (Windings, MS Outlook etc.) Few quick tips: To make a bar graph Use the REPT(char) function in Excel to repeat a character. Choose from the list of symbols ...
Continue Reading

Comments (1)

Stress Test Results – A Classic Visualization Challange

Posted on 08 May 2009

Stress Test Results - A Classic Visualization Challange
The results of the "Stress Test - Housing Crisis of Shame" are out. I just saw NY Times publish the stress test figures this morning. The first thing that came to my mind when I saw the results was, well.......not that they require another $75 billion, that's pretty well known to most of us by now, was ....gosh.....what an opportunity wasted. Here was a important and relevant piece of data that could have really been presented better using ...
Continue Reading

Comments (1)

How to create an Excel Flow Chart – (Template and Software)

Posted on 04 May 2009

How to create an Excel Flow Chart - (Template and Software)
This tutorial shows how to create a Flow charts in Excel. Flowcharts help you logically represent a sequence of activities in a process. Before you begin, you may want to download and analyze this sample flowchart template created using excel. Making flowcharts in Excel can be as easy and fast as it is in Microsoft Visio without having to buy a license for the later. If you work in a company where a lot of planning and process engineering ...
Continue Reading

Comments (4)

Stations along the Science Railroad !

Posted on 03 January 2009

Stations along the Science Railroad !
muyinteresante published this delightful map of progress of various branches of science and the personalities that helped them evolve. It took me a while to study the entire thing but I did end up with a pleasant sense of completeness even though the various 'scientists' (I use that term loosely to include philosophers, astronomy, biology and others) may have lived in periods separated by many years or even centuries. My guess ...
Continue Reading

Comments (1)

USA Today does some good work

Posted on 07 November 2008

USA Today does some good work
I mentioned in one of my previous articles that for data visualization to become truly interactive one may need to explore newer avenues. I was mighty impressed by this graphic behind the results that appeared in USAToday recently. Here’s why: 1. The authors (Analysis: Paul Overberg of USA TODAY and Robert Lang of Virginia Tech and Graphic: William Couch and Juan Thomassie, USA TODAY) ...
Continue Reading

Comments     

Interesting heatmaps

Posted on 18 October 2008

Interesting heatmaps
Heatmaps allow us to visualize the change in a particular variable over a certain period of time or area. I found some neat heatmaps that were worth sharing. Person scanning a website (Courtesy: Tobii.com) Change in economic indicators under each President (Courtesy: NY Times) UV Levels across the globe on 18-OCT-2008 (Courtesy: Temis.nl)...
Continue Reading

Comments     

Bulls, Bears, Donkeys and Elephants

Posted on 16 October 2008

Bulls, Bears, Donkeys and Elephants
Who would want to use something like this..... (See Bulls, Bears, Donkeys and Elephants ) ......when they could've used this instead.....
Continue Reading

Comments     

How to create waterfall chart in excel in 2 minutes

Posted on 08 October 2008

How to create waterfall chart in excel in 2 minutes
A waterfall chart is used to represent a set of figures when they all impact the same derived number. A waterfall chart helps to link the individual values to a whole. A profit and loss statement is a good example where the magnitude of each figure has an impact on a derived number (which happens to be Profit in this case). A colleague of mine recently had a budgeting exercise assigned to him where he had to project the P&L figures ...
Continue Reading

Comments (43)

Bar(ring) Chart

Posted on 07 October 2008

Bar(ring) Chart
I have always been a big fan of New York Times especially when it comes to creating cutting edge graphics. A few are mentioned in some of my previous posts. NY Times - Home Foreclosure Graph and The rise and fall of movies - NY Times. However once in a while, they err and publish..well...lets say less than world class charts. To my dismay one such chart was published recently: Home Prices in Selected Cities Through July ’08 ...
Continue Reading

Comments     

Going online with your excel charts

Posted on 20 September 2008

Going online with your excel charts
Excel provides a way to convert the charts in an excel workbook to a webpage. To move your charts online, select the chart and use the Save as option to save the chart as a .mht/.mhtml web page. What's more, the charts on the web page are interactive....changing values in the worksheet reflect in the chart elements. A very useful, though a little cumbersome, way of publishing chart intensive dashboards, reports and ...
Continue Reading

Comments     

Global Traffic Map

Posted on 11 September 2008

Global Traffic Map
Telegeography carried out a study of the global internet traffic. Some very informative charts are available on the site including this one. The US continues to be the hub of global traffic.
Continue Reading

Comments     

So what are my chances mate !

Posted on 09 September 2008

So what are my chances mate !
WSJ ran this graph that shows the probability of a person's dying through various causes. Topping the "death chart" are heart disease (1 in 5), cancer (1 in 7), stroke (1 in 24) and motor vehicle accident (1 in 84). The probability that one will die by drowning is 144 times than being killed by flooding.
Continue Reading

Comments     

NY Times – Home Foreclosure Graph

Posted on 07 September 2008

NY Times - Home Foreclosure Graph
This appeared some time back in April-2008. What is interesting to note is that not only this chart is visually appealing but it does pack a lot of data. The color of the stacks shows the % of subprime mortgaes as a % of all mortgages in an area while the height of a stack shows subprimes mortgages foreclosed as a % of all subprime mortgages in that area. If ...
Continue Reading

Comments (1)

Creating tree structure in excel

Posted on 06 September 2008

Creating tree structure in excel
You can use the group and outline features in excel to create tree structures. On expanding each node the next branch becomes visible. You can download the file here.
Continue Reading

Comments (1)

The Internet is an Interesting Place…

Posted on 06 September 2008

The Internet is an Interesting Place...
....and that's partly what got Barrett Lyon to create this beautiful map the internet by locating each C Class network in it. I think this has great potential. For example and as Lyon mentions on his site, if you get a chance to look at two pictures of a geographical location before and after a disruptive event takes place(like an eartquake or a Tsunami), this can give ...
Continue Reading

Comments     

  • Page 1 of 2
  • 1
  • 2
  • >

Subscribe

Keep up with the latest stories - Delivered right to your inbox
feedburner

Translate

English flagItalian flagKorean flagChinese (Simplified) flagPortuguese flagGerman flagFrench flagSpanish flagJapanese flagArabic flagRussian flagDutch flagHindi flagFilipino flagIndonesian flagThai flagTurkish flagPersian flag
treeemap software for excel


ARCHIVES