In fact, don’t do this ever. Today’s bad chart comes from the Philadelphia Mayor’s Office of Transportation and Utilities. I saw it and could only shake my head and wonder why.
The Mayor’s Office version
Something more like this much more easily communicates the story.
My take on the data
Credit for the original piece goes to the Mayor’s Office of Transportation and Utilities.
So Ukraine is even more of a mess and in less than a week’s time, the Crimean people will vote in a referendum on whether they want to remain a part of Ukraine or rejoin Russia. This graphic of mine is an attempt to answer some questions—though hardly all I wanted—about Ukraine, Crimea, and about what the Russians have been doing. (To be fair, the Russians still don’t admit that the troops and soldiers are theirs. But really, I mean come on, we all know they are.)
The West hesitates to use military force to push Russian troops out of Crimea. Likely with good reason as any such campaign would be neither cheap nor bloodless in addition to running the risk of spreading beyond the borders of Ukraine. So that leaves diplomatic and economic isolation. Diplomatic isolation is already underway—the G8 conference to be hosted in Sochi this summer is all but dead. But economic isolation is still being discussed.
Isolating Russia
The United States is generally in favour, but Europe—namely Germany—has been more cautious. But as my graphic shows, without Europe a sanctions regime would be largely toothless since half of Russia’s exports go to Europe. Except that Russia is also responsible for a significant proportion of Europe’s imported natural gas and sanctions on Russia could cause an interruption in that fuel to Western Europe. Naturally, most of that natural gas is, of course, transported through pipelines running across Ukraine.
A lot of things happened in Ukraine this past weekend. Unfortunately, I was not able to quite capture all of the events and the background I wanted. So, until I do, this quick graphic will have to suffice. In short, Ukraine is a big European country, one of the largest prizes remaining in the struggle between the West/EU and the East/Russia. I took a look at the forecast for Ukraine in 2050 for both number of people and the size of the economy and put that in the context of Europe. And while forecasting that far out clearly has risks, one can see with a grain of salt that Ukraine is set to be an important middle-sized European nation.
A quick introduction to Ukraine
But, like I said, there is more to do. I just was not able to do it.
So yeah, the Super Bowl thing. Apparently tickets are expensive? Earlier, Bloomberg Businessweek took a look at average prices for the most expensive events of 2013. The only sentence supporting the graphic was that the most expensive event was not the Super Bowl. Okay, so what was?
Most Expensive Average Ticket Prices
I think this graphic actually makes it more difficult to tell. But beyond that, the decision to use the tree map confuses me. We are already looking at a subset of ticket prices—not all, but only the “most expensive”. What criteria determined that selection? After all, from my own experience and personal knowledge I know that Red Sox–Yankees game are also incredibly expensive. But those are not present in this set. And then if the idea is to undermine the common thought that the Super Bowl is the most expensive ticket, should the user be forced to find through each square—and no, the events are not squarified very nicely—the highest value?
So I took an hour before the game to try a quick stab at quickly identifying the most expensive tickets. It turns out that the glorious bar chart more than suffices. It also then shows how quickly the remainder of the prices become quite comparable. (Ridiculous I suppose depends upon your preference for sport/event/disposable income.)
My quick take
Credit for the original piece goes to Bloomberg Businessweek.
We enter our second week of the government shutdown. Of course, blame for the shutdown falls largely upon a small number of conservative Republican members of the House, bolstered by Senator Cruz (R-TX) and his allies in the Senate. But we already know that there are a number of moderate Republicans who want to pass a clean budget resolution. So one way of looking at this new conservative faction is as a new minor party in a coalition government with Ted Cruz as Party Leader.
The idea is not mine. Ryan Lizza first wrote about the “Suicide Caucus”, a topic that Philip Bump expanded upon several days later. However, as a thought experiment, I was curious to see what would happen if this third party, a Conservative Party, would look in data visualisation terms. So here’s a quick stab at America’s newest third party.
I was catching up on some news tonight and I came upon an unhelpful graphic that was supposed to be helping me understand the whip count (who is voting yes or no) for authorising the use of force in Syria. Below is the original graphic from Think Progress.
The whip count as of 15.30 on 3 September
I struggled, however, to directly compare the yes and no votes. While I certainly understand that the splits within both parties are a fascinating subplot to the greater issue of will we bomb Syria, the traditional congressional arc visualisation is not helpful here. So using the same numbers, I simply plotted what is essentially a stacked bar chart. In truly heretical, i.e. independent, fashion I mixed the two parties together and placed them at either ends of the chart. The first to reach 50% wins. (If I were updating this live of course.)
My visualisation of the whip count…
Credit for the original goes to Igor Volsky and Judd Legum.
I did not have quite enough time to develop this piece to what I wanted, but for now it will have to suffice. I wanted to look at the situation in Syria, but I only had time to outline who has what near Syria. Click the image for the larger version.
Fear not, this graphic makes about as much sense as the title. The concept is actually a worthwhile exploration of the variation in caffeine across cups of coffee from different cafes and coffee shops. But, this visualisation fails at showing it.
Coffee Pie Charts
Remember, pie charts show the piece amongst the whole. What is the whole in this case? A cup of coffee? No, the data labels indicate milligrams per fluid ounce. It appears as if 60mg./fl. oz. is the whole. A bit arbitrary that. So what happens if you lose the trite pie as a cup of coffee device and simply chart the values. Oh wait, that’s not very hard to do. (I also threw in what I believe to be the benchmark for an average cup of brewed coffee, though I could be wrong.)
Coffee Bar Chart
Much clearer. More concise (I used less than the original’s dimensions).
Credit for the original piece goes to Dan Gentile.
At lunch, I felt inspired enough to create a quick chart that looks at some urban population statistics.
Top-10 Cities Population
A caveat about the data, it comes from the Census Bureau’s tables on the top-100 cities. So until a city appeared on that list, I did not chart it. The exceptions are 2000 and 2010, where I pulled directly from those census results. Mostly because it was lunch and I needed to be quick about it.
Hint, US Census Bureau, make your interface more friendly.