Makeover Monday Challenge February 29 2016

Today’s Makeover Monday from Andy Kriebel and Andy Cotgreave looks at the growth in UK soccer player salaries over the last 30 years. The original article is here and the key visual they asked people to make over is this:

Original Donut Graphs

Because the author included the average UK worker income, I thought that the key insight would be to see how the salary growth in each level compared to the growth in the average worker salary. Are the salaries in each level growing at about the same rate as the average worker, or are we seeing much higher growth at the top levels, as we see in the overall population.

I calculated the compound annual growth rate (CAGR) for each of the groups. I wanted to compare each level in soccer against the average worker, so I used a bar chart with a dashed line for the average worker. Here is the visual I created:

Makeover Monday Feb 29 2016

The bottom two levels of UK professional soccer have salary growth just higher than that of the average worker. The top two levels show growth more than double and triple that of the average worker. The conclusion? In soccer, as in the general population, we are seeing much higher income growth at the top levels.

Tools used: Excel 2010 to do the calculations; PowerPoint 2010 to create the graph (the technique to create the dashed line as a second chart type with a bar graph is explained in my Implementation Guide for Creating Graphs and Visuals for Data)