Football Transfer Spending

Juventus and Barcelona were the most active when combining  football transfer spending and earnings, as shown in this scatter chart. Other very active clubs were AS Monaco, Borussia Dortmund, Chelsea FC, AS Roma, Atletico Madrid and Real Madrid. Manchester City was the biggest net spender with Manchester United close behind. LOSC Lille was the biggest net earner with Olympique Lyonnais second. Most clubs in the top 5 leagues were much less active in the football transfer market and are clustered in the lower left hand corner of the scatter chart. Data were combined from the last 10 football transfer windows by CIES Football Observatory.

Football Transfer Spending and Earning in a Scatter Chart

How I Made this Scatter Chart 

Here is the football transfer data I used to create the scatter chart:

Here's how I made the chart:

• copy the data from CIES Football Observatory into Excel
• use Excel formulas to create the data needed to fill the spreadsheet above
• create a scatter chart in PowerPoint based on the Excel data
• adjust chart margins and axis scales to make the height and width of the chart area the same scale
• add axis titles and custom suffix to axis labels
• place legend in lower left and increase marker size
• hide series labels for all data points in lower left of chart
• move other series labels to make the chart easier to read
• bold the Lille and Manchester City labels

Take This Chart and Make It Your Own

Download this chart and edit it using Mekko Graphics. See more scatter charts in our chart gallery. Here are some other charts that may be of interest:

• Most Expensive Footballers

• Value of European Football Squads

• Top English Premier League Goal Scorers