5 Beautiful Visualizations [Oct 24]

Every week, Pointy Haired Dilbert celebrates the art of chart making by sharing 4-5 of the most beautiful visualizations floated around the web in the last few days. Take a look at them and have some inspiration and fun
Map of most popular social networks in each country

This is a simple world map, but [...]

Sports Statistics Dashboard in Excel - Few More Alternatives

First of all, thanks everyone for making the should you always start barcharts at zero? discussion lively. Almost everyone felt that we should start bar charts at zero.
After spending sometime with my initial test cricket statistics dashboard, I have created few alternatives. You can see them below.
But somehow I feel that I haven’t found very [...]

Reader Poll: Should the axis for bar charts always start at zero?

It all began with my Excel Dashboard Tutorial - Making a dashboard with player statistics. I have used bar charts with axis whose minimum is not zero, to create a dramatic effect in the charts. See below:

Jon Peltier commented saying that,
Rule #1: Bar and column chart value axes should start at zero. Since the lengths [...]

Sports Dashboards in Excel - A Tutorial

One of my favorite cricket player, the GOD - Sachin Tendulkar has become highest test run scorer.
What do I get if Sachin becomes highest scorer, you may ask.
In order to celebrate this occasion I have created a cool sports dashboard in excel with some of the top test cricket players’ statistics. And, you get [...]

The New Poor - Internet Penetration Rates by Country

Yesterday is Blog Action day and tons of bloggers posted about single topic - poverty. It is a topic very close to my heart for various reasons. It is a very sad thing not to have food or shelter or healthy living conditions. But man has thrived in all those situations just because he learned [...]

The Secret Sauce of Exceptional Dashboards - Visualization [Part 1 of 2]

This is a Guest Post by Robert on Visualization Techniques for Excel Dashboards.
With the dashboards using excel - 4 post series here at Pointy Haired Dilbert we developed a small dashboard that enables the user to scroll within a larger set of data, to sort by a selected KPI with one click, to identify the [...]

Replace Radar Charts with Tables to Make Comparison Easy

In Petal Charts - an Alternative to Radar Charts I have suggested using a radar chart tweak to replace the radar charts. Both PTSBlog and Information Ocean have posted their critical reviews of these petal charts.
So as a penance for proposing petals, I am going to provide a tutorial on creating a comparison table [...]