Marimekko chart of transfer spending for each squad in top 4 European football leagues, highlighting spending of top clubs in each league.

Value of European Football Squads

The top 5 squads in the biggest leagues in European football account for between 50-75% of each league’s total transfer expenditure, as shown in this Marimekko chart.  English Premier League teams spent the most with Manchester City's squad costing over 1B euros. Spain's La Liga and France's Ligue 1 were the most top heavy with 5 squads spending 75% of the league's total.  Data from CIES Football Observatory as of September 2019.

Value of European Football Squads in a Marimekko Chart with Data Rows

Marimekko chart of transfer spending for each squad in top 4 European football leagues, highlighting spending of top clubs in each league.

How I Made this Marimekko Chart with Data Rows

A snapshot of the data on the transfer spending for each European Football squad and a related PivotTable is shown below:

Data for Marimekko chart of transfer spending for each squad in top 4 European football leagues, highlighting spending of top clubs in each league.

Here's how I made the Marimekko chart with data rows:

  • copy the data from the CIES website into a word document
  • convert the text to a table in word and copy the table into Excel
  • create a PivotTable from the table with rows for each European football team and columns for each league
  • create a Mekko Graphics chart in PowerPoint based on the data in the PivotTable (excluding total row and column)
  • use the sum and count formulas in the Mekko Graphics Data Editor to add data rows for number of teams and average spend per team in each league
  • add an "Other Series" in Format Bars and Series tab to group spend from the smallest teams in each league
  • sort data so that the biggest series are on the bottom and widest bars are on the left
  • use Color by Bars in Format Chart to give all teams in each league a unique color
  • adjust internal chart margins to maximize space for the chart area
  • show data values with labels in each segment
  • format data values and bar totals to show as millions of euros
  • show percentage of total next to bar totals (available on right-click menu for bar total)
  • format average value data row to show as millions of euros
  • uncheck autowrap for data row labels to have them display on a single line
  • color all segments, except for top 5 in each league in light gray to highlight percentage of spend accounted for by top 5

Take This Chart and Make It Your Own

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