Adam Pode's Blog

Marimekko to you to

A ‘Mekko’ chart is said to have gained the name because it resembles a print developed by the Finnish Textiles and Fashion group - Marimekko

The chart's design shows two variables in the case of our recent briefing - the size and level of consolidation of the largest four staffing markets in Europe. Putting together such a chart using Excel 2013 is not hard. It takes just three steps and using the date from the briefing I will show you how.

Step 1 - Sort out your Data

For this chart we have the four largest staffing markets France (€20,947 million), Germany (€20,844 million), Netherlands (€14,321 million) and the UK (€28,211 million) worth in total €84,323 million; or approximate 25%, 25%, 17% and 33% each.

Then we have the combined list of firms who are in the top five for each country. There are Adecco, Manpower, Randstad, Groupe Crit, IT Staffing, Hays, Impellam, Persona, Reed, Synergie and USG People.

The data is arranged as follows (click on any of the graphics to enlarge them). 

The figures in Row 2 are derived from the market share shown above. So for example the data for France with a market share of 25%, runs from 0 to 25. The UK starts at 67 because this is cumulative market share of France, Germany and the Netherlands (25%, 25% and 17%) which comes before and runs to 100.

The company market share for each country (the Y values) is shown twice. Thus in France (Columns B & C) Adecco has a 24% market share, Manpower 20%, Randstad 15%, Group Crit 5% and Synergie 4%. None of the others firms market share is shown as they are not in the top five. However we have calculated and entered the the remaining market share for all firms in the marketplace, as follow:

Size of the total market (100%) – Top 5 Market Share (69%) = Other (31%)

Step 2 - Creating the Chart

Select all the data except that in row 1 data and create a 100% stacked area chart (Insert – All Charts – Area 100% Stacked Area. 

The chart will look like this.

Select the bottom axis and press Ctrl+1 (numeral one) to open the Format Axis dialog. Under Axis type (its at the top), change Automatically Select to Date Axis. The chart will look like this

You can then delete the data in the bottom axis (what looks like gobbledygook above), as well as the legend and chart title. You might also want to add solid line boarders as this help to visually differentiate the segments.

Step 3 – Label the diagram

My approach is to drop this chart into PowerPoint and label it there by using the add text feature. However if you want to be more sophisticated Jon Peltier has some suggestions, which you can read here.

Its as simple as that. As ever if you have any improvements to this approach please don’t hesistate to drop me a line.

Comments

Add New Comment

Post comment

NOTE: Links will not be clickable.
Security text:*

Recent Blog Posts

How do I get there?

The staffing industry is now truly multinational. Our survey of the world’s three largest staffing companies – Adecco, Randstad and ManpowerGroup – showed that the latter firm has the broadest geographical... Read More

What the time?

When arranging a meeting with a colleague in a different time zone many people will send an Outlook meeting request.

Time for items in the Outlook Calendar is stored based on Greenwich mean time (GMT) sometime... Read More

It’s not about the money, money, money

Unlike the lyrics of Jessie J’s excellent song "Price Tag" this blog is all about the money. With the role out of our Rest of World research reporting (excluding North America) from January... Read More

Bubbles

Like my blog on x y scatter graphs, I have posted today because I came across a problem that has taken me some time to solve and I hope you will save time by reading this.

A chart with bubbles to show the... Read More

Keep it Legal

I came across an excellent blog this week on “How to Use Google Images Without Getting Sued” from Jessica Dobias.  The article and accompanying video highlighted some of the advantages of Gooogle... Read More

Google is so last year

I am “old” enough to have lived through the dot.com bubble. After which a large number of useful online resources and technologies disappeared because they could not answer the question “who pays?” ... Read More

Scatter Yourself

I have just spent a very frustrating couple of hours trying to add text labels to a xy scatter chart.  Only to find out that in Microsoft Excel 2010 “there is no built-in command that automatically... Read More

Fishing

You may well have heard the Chinese proverb that if you give a man a fish, you feed him for a day. But if you teach a man to fish, you feed him for a lifetime.  Our purpose here at Staffing Industry... Read More

So you think you’re an analyst

Do you like puzzles, word games or murder mysteries? I have set out three tests that I think you will find of interest.

Our own survey helps you test your business skills and identifies for us analysts... Read More