Posted on 15 September 2009
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 ...
Posted on 03 July 2009
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 ...
Posted on 29 June 2009
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 ...
Posted on 11 June 2009
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
Posted on 21 May 2009
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 ...
Posted on 08 May 2009
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 ...
Posted on 04 May 2009
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 ...
Posted on 03 January 2009
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 ...
Posted on 07 November 2008
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.
1. The authors (Analysis: Paul Overberg of USA TODAY and Robert Lang of Virginia Tech and Graphic: William Couch and Juan Thomassie, USA TODAY) ...
Posted on 18 October 2008
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
Change in economic indicators under each President
(Courtesy: NY Times
UV Levels across the globe on 18-OCT-2008
Posted on 08 October 2008
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 ...
Posted on 20 September 2008
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 ...
Posted on 11 September 2008
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.
Posted on 09 September 2008
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.
Posted on 07 September 2008
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 ...
Posted on 06 September 2008
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
Posted on 06 September 2008
....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 ...