Motion charts are a great way of visualising trends and patterns in data and showing several dimensions simultaneously.
The concept was first developed several years ago by a company called Gapminder and popularised by its founder, Professor Hans Rosling, in a much acclaimed lecture on the developing world. In 2007 Google acquired Gapminder's Trendalyzer software which incorporated motion chart technology. Google now make their own motion chart API freely available via the Internet.
We have used this technology to bring to life some of the information contained in Statistics Relating to Lloyd's through a series of case studies. The case study shown here uses anonymised samples of the data contained in Statistics Relating to Lloyd's. For access to the unrestricted version (i.e. all syndicates shown) please click here.
Syndicate Summary Financial Statements
A visual representation of the type of data found within the syndicate financial statements.
The chart above can be used to visualise Syndicate Summary Financial Statements from the Statistics Relating to Lloyd's. The data used in this chart is based upon a random set of syndicates that have been anonymised (syndicates have been labelled A to I).
In the default example above, the size of the bubbles corresponds to Net Earned Premiums (£M) and the colour is unique for each syndicate.
Activate the motion chart by clicking on the play button (bottom left corner of chart). You can watch the size of the bubbles change as NEP values change over time. The bubbles move around the chart to illustrate changes in NPW and pre tax profit.
The power of visualising data in this way becomes much more apparent when viewing all Lloyd's Syndicates in the chart. You can access the unrestricted version by subscribing to Statistics Relating to Lloyd's.
Create Your Own Motion Chart
With Google's API, creating motion charts like the ones above is reasonably straightforward. More details can be found on their website. If you have any questions about these charts, how to build your own charts, or any general feedback, please email us at Stats@Lloyds.com.
Excel Motion Chart
As an alternative to using Google motion charts, Lloyd’s Business Intelligence team have developed an Excel version that mimics much of the functionality of the Google charts. The advantage of using the Excel version is that you can run it from your desktop.
Download your free Excel Motion chart.xls