Correcting Wiki Charts: Mauthausen-Gusen

My third pick from the list of abhorrent Wiki charts mentioned by Jorge Camoes is the one from the page of Mauthausen-Gusen, originally a collection of villages of Mauthausen and Gusen in Upper Austria, which became one of the largest Nazi concentration camps by the summer of 1940 and the place of death of several hundred thousand inmates.

There are several reasons for finding this serving of pie unpalatable. Firstly because it is a "Pie Chart". This same data could be more easily and effectively displayed using a column or a stacked bar chart. Secondly, because it is an exploded pie chart. I prefer an exploded pie-chart where the exploded slice merits special attention from the rest. To otherwise create this type only succeeds in bringing a ragged look to an already poorly crafted chart. Third, and most importantly, the use of flags as legends and with it, the redundant use of data labels to state the name of the countries that is absolute chart junk! I'd either have the flags or the names as legends.

I've replaced the exploded pie-chart in favour of a 100% stacked-bar chart. Labelling the flags with the name of their nations didn't appeal to me much, hence the only labels in the chart are those showing the death percentage for every country.

This is my version of the Mauthausen-Gusen chart.

Comments

The Dorling Cartogram

My last project involved using a multitude of regions for drawing analysis, parallels and comparison. Not wanting to use yet another Choropleth graph, I decided to look up alternatives that were easier to create and preferably required no VBA. Soon I stumbled upon "The Dorling Cartogram", defined in the UCSB site as, "This type of cartogram was named after its inventor, Danny Dorling of the University of Leeds. A Dorling cartogram maintains neither shape, topology nor object centroids, though it has proven to be a very effective cartogram method. To create a Dorling cartogram, instead of enlarging or shrinking the objects themselves, the cartographer will replace the objects with a uniform shape, usually a circle, of the appropriate size." I had the data for Obesity in the United States handy, so I decided to give it a try before using it in my project. I opted to use Bubble charts because data points within a series may need to be of varied shapes based on

The Pie-Doughnut Combination: A Fan Plot

Happy to be back after a pretty busy beginning to the new year. I had this completed almost immediately following the preceding post but was otherwise hard-pressed to find a suitable time to post it. Soon after writing the Florence Nightingale Circumplex Chart post, I started searching for more varieties of charts that can be created using combinations of Pie-Doughnut charts. Soon enough, I found one through Naomi B. Robbins' comment in a Jorge Camoes' post . The referenced PDF article attempts to use Fan Plot to display relative quantities and differences using the R statistical language as is shown in the image below. Impassive of its benefits and/or disadvantages, I created it in Excel.

Florence Nightingale Circumplex Chart

I was taken to the Florence Nightingale's Wiki page during a recent research, and one of the interesting things I noted was her contribution to statistics. It came to me as a pleasant surprise that she is credited with inventing the polar area diagram , or occasionally the Nightingale rose diagram, which is equivalent to a modern circular histogram. Following the completion of my project and in my weekend to spare, I devoted time to recreating the chart in Excel. It took a combination of Doughnut-Pie-and XY charts and close to four hours to finish it. The colours are a bit darker, the values are approximate and the labels differently oriented, yet the chart looks fairly close to the original as is shown by the picture below.

Somnath's Excel Charts

Search This Blog