Telecoms companies: who’s suing who?

There’s a chart doing the rounds that shows who is suing whom in the telecoms industries (eg at the Guardian). David McCandelish has improved it nicely here, and asked the question of whether companies who’s revenue is going down are more litigious than those on the rise. Well, I took his data from here and created the charts below.

There are lots of caveats: I excluded Smartphone Technologiess LLC because the data didn’t say if their revenue was up or down. That’s a shame, because they’ve got the most lawsuits open. Also, we don’t know if the revenue was going up or down when the lawsuit was started.

PS – for Tableau geeks, the tooltips on the chart are using my Conditional Formatting trick (click here) to make the text colour change depending upon Revenue Direction.

General election 2010

Here in the UK we have just been through (and, at the time of writing, are still enduring) a general election. This presents us with some fantastic datasets. The first place I turn to is the Guardian Data Store, and they provided this, which allowed me to create Election results dashboard below.

I won’t comment much on it, but it does utilise three tricks that I hope to explore and explain in the coming weeks:

  • Hyperlinks on sheets
  • Conditional formatting on tooltips
  • Positioning the text label in the bars

Enjoy the viz, and please post and comments below.