How to Create Mekko/Marimekko Chart in Excel (With Easy Steps)

To generate the Mekko chart, we have taken the following dataset of different Markets and corresponding Company shares.

Step 1 –  Create Helper Table

To create the Mekko chart, we need to create a helper table so that we can input data into a chart and make a Mekko chart.

• The blank column before Co. 1 will be later filled with Horizontal Axis Values.
• Leave the first row (Row 5) within the Helper Table blank.
• Copy the Market A share of 4 companies (D5:G5) and paste it 3 times in the table as shown in the following image.

• Leave a row blank and copy all the Company Shares of Market B and Paste it 3 times.
• Repeat the procedure for Market C and Market D.
• The following image shows how it should look.

• Enter 0% in each of these blank cells.

Step 2 – Find Horizontal Axis Values for Buffer Rows

• To insert the Horizontal axis values in the left blank column, we need to set a custom format for the column.
• Select the column area as shown in the following image.
• Press ‘Ctrl + 1’.

• The Format Cells window will open.
• From the Number tab, select Custom.
• Set the custom format to 0“%”.
• Press OK.

• Set the upper and lower Axis values for each Market.
• The share of Market A is 20%. So, the upper and lower values of Market A will be 20% and 0%.
• The share of Market B is 35%. So, the upper and lower values for Market B will be 55% and 20%.
• Fill in the upper and lower values of Market C and Market D in the same way.

• Fill the axis values adjacent to the buffer rows.
• The value in these cells will be the same as the previous and the following axis values.

To find the midpoint values of each market.

• Add the following formula in I7 to find the midpoint for Market A.

• This will give you the first midpoint which is 10%.

• Follow the same procedure to find the midpoints for the other markets.

Step 3 – Add Label Marker and Label

• We now need to add Marker and Label in our helper table.
• In the Marker column, fill 100% in the midpoint rows.

• Add another blank column Label.
• You can add the Labels manually or use the following formula in O7 to get the Label.

• Modify the cell references to add Labels for other midpoints.

• Add the company shares as shown in the following image.

• We can use this table to create a Mekko chart.

Step 4 – Insert Stacked Area Chart

• To create a Mekko chart, we have to insert the data range I4:N21 in a Stacked Area Chart.
• Select the data range I4:N21.

• Go to the Insert tab.
• From the Insert Line or Area Chart group, select the Stacked Area chart.

• The stacked area chart should look like this one.

Step 5 – Change Chart Type of Marker Series

To modify the Stacked Area chart,

• Select any of the upper triangle sections.
• Right-click on your mouse.
• Select Change Series Chart Type.

• A new window named Change Chart Type will appear.
• Change the chart type of the Marker series to Line with Markers and press the OK button.

Step 6 – Add and Format Data Labels

• Right-click on the Marker series.
• Select Add Data Labels.

• You can see all the data labels of the Marker column.
• Right-click on any of the Data Labels.
• Select Format Data Labels.

• The Format Data Labels window will open.
• From the Label Options, select Value from Cells.
• A new window named Data Label Range will appear where you have to select the Label range.
• Select the data range O5:O21 and press OK.

• Uncheck the Value and set Label Position to Above.
• The data labels are aligned above the chart with proper labels.

• We can hide the Marker lines.
• Select the Marker series and Right-click.
• Select Format Data Series.

• From the Fill & Line section select No line.
• Go to the Marker section.

• Select None from the Marker Options.

Step 7 – Format Horizontal and Vertical Axes

• Right-click on the Horizontal axis.
• Select Format Axis.

• Go to Axis Options and select Date Axis.
• As soon as you select the Date Axis, the chart will change into a Mekko shape.
• Change the Major and Minor Units to 10.

• Right-click on the Vertical axis and select Format Axis.

• From the Axis Options, set the Maximum as 1.

Step 8 – Insert Chart Data Labels

• All the different colors represent series for different companies.
• Right-click on the yellow color series (Co. 1).
• Select Add Data Labels.

• This will show all the data labels for Co. 1.
• Right-Click on any of these data labels.
• Select Format Data Labels.

• The Format Data Labels window will open.
• From the Label Options, select Value from Cells.
• A new window named Data Label Range will appear where you have to select the Label range.
• Select the data range S5:S21 and press OK.

• Uncheck the Value.
• You can see the data labels for Co. 1 are shown within the yellow chart area.

• Add the data labels for all other companies and it will look like the following image.

• Right-click on the chart area.
• Select Outline.

• Choose a suitable outline color.
• Choose a preferable outline Weight.
• Press OK.

The final Mekko Chart will look like the image below.

Read More: How to Create Activity Relationship Chart in Excel

Things to Remember

• Make sure to create a proper helper table. The values and formatting in the helper table are important.
• Keep a backup file of your original dataset before starting the helper table.
• You can fill in different colors and make other changes in your Mekko/Marimekko chart in Excel.

Frequently Asked Questions

1. What types of data are suitable for Mekko charts?

Mekko charts are useful for visualizing data distribution between two categories. Typically, market shares and market sales are represented in a Mekko chart.

2. What is the purpose of a Mekko chart?

The purpose of the Mekko chart is to show categorical data. It comprises of different stacked bars with varying widths. It is also known as a mosaic plot. This chart type is important for showing data distribution for different categories.

Download Practice Workbook

Related Articles

• How to Make a Budget Constraint Graph on Excel
• How to Create a Weight Loss Graph in Excel
• How to Find Intersection of Two Curves in Excel
• How to Show Intersection Point in Excel Graph

<< Go Back to Excel Charts | Learn Excel