Excel Functions Tutorials
- Excel Charts
- Types of Charts in Excel
- Area Chart in Excel
- Bubble Chart in Excel
- Chart Templates in Excel
- Change Chart Style in Excel
- Calendar Template in Excel
- Inventory Template in Excel
- Clustered Bar Chart in Excel
- Clustered Column Chart in Excel
- Column Chart in excel
- Combination Charts in Excel (Combo)
- Excel Combo Chart
- Control Charts in Excel
- Doughnut Chart in Excel
- Dynamic Chart in Excel
- Excel Chart Wizard
- Flow Chart in Excel
- Flowchart Excel Examples
- Funnel Chart in Excel
- Gantt Chart in Excel
- Gantt Chart Example
- Gauge Chart in Excel (Speedometer)
- Graphs vs Charts
- Histogram Excel Chart
- How to Make Graph / Chart in Excel?
- Legends in Excel Chart
- Line Graphs / Charts in Excel
- Line Chart Examples
- Marimekko Chart in Excel (Mekko)
- Normal Distribution Graph in Excel
- Organization Chart in Excel
- Pareto Chart in Excel
- Pie Chart in Excel
- Make Pie Chart in Excel
- Pivot Chart in Excel
- Radar Chart in Excel (Spider Chart)
- Stacked Chart in Excel (Column, Bar & 100% Stacked)
- Stacked Bar Chart in Excel
- Stacked Column Chart
- Stock Chart in Excel
- Scatter Plot in Excel (Chart)
- Tornado Chart in Excel
- Dot Plots in Excel
- 3D Plot in Excel
- 3D Scatter Plot in Excel
- Standard Deviation Graph in Excel
- S Curve in Excel
- Waterfall Chart in Excel
- Financial Functions in Excel (17+)
- Logical Functions in Excel (15+)
- TEXT Functions in Excel (29+)
- Lookup Reference in Excel (44+)
- Maths Functions in Excel (52+)
- Date and Time Function in Excel (22+)
- Statistical Function in Excel (50+)
- Information Functions in Excel (5+)
- Excel Tools (98+)
- Excel Tips (178+)
- VBA (162+)
Marimekko chart is also known as a mekko chart in excel, this chart is a two dimensional combination of both 100% stacked column and 100% stacked bar chart in excel, the creativity of this chart it is that it has variable column width and height, this is not a built-in chart template in excel but however there are other ways to make this chart in excel.
Excel Marimekko Chart
For all those who are excited about the Mekko chart with unfortunately there is no built-in chart with excel. So, if there is not a built-in chart of Marimekko how do we build this chart?
The answer is we need to recreate or restructure our data to create a Marimekko chart. In this article, we will show you how to rearrange the data to create a Mekko chart in excel. With the data first, we will create a stacked area chart than by making some tweaks to the chart we will be able to create a Marimekko chart.
In the below section of example, we will show you how to build a Mekko chart in excel.
How to Create a Marimekko Chart in Excel Spreadsheet?
Below is the example of a Marimekko chart in excel.
As I told, in the beginning, the Marimekko chart is very useful to show the performance of different companies who are competing in the same market sector. For this example, I have created a simple data sample as below.
This is the data of companies market share i.e. column 2. In each market, each company shares percentage which is summing up to 100 in each market.
For an example in Market 1 Co., A has the market share of 30 but in Market 5 it has only 12. So like this data is.
Now in order to create Marimekko chart we need to rearrange the data, this includes a lot of complex excel formulas.
First, create a company list below.
In B10 & B11 enter values as zero.
Now in B12 apply below formula.
This is used to create a running total of market share. Once the formula is applied copy down the formula to below cells until the B28 cell.
Now in cell C10 apply below formula.
This used to create three values stack where the initial value is always zero, 2nd and 3rd values is the repetitive value of Co., A share in Market 1 & Market 2. Like this going forward, it will create three values of each market sequence.
Once the above formula is applied to the cell C10 copy down and to the right as well.
Now the calculation is over, the next step is to insert the chart. Select the data from B10 to G28 and click on the recommended chart.
Go to the area chart and choose the below chart.
Click on OK, we will have a chart like the below.
Select the horizontal-vertical axis and press Ctrl + 1 to open format data series to the right.
Change the Axis Type to “Date Axis”, major is 20, minor is 100.
Now we have a nice looking chart like the below.
Now we need to insert data labels to this Marimekko chart. So we need to create one more table to the right of our first table.
In a cell, I2 apply the below formula.
In a cell, J2 apply below formula and paste to other cells to the down.
Now in K2 cell apply below formula.
Copy the formula to down cells and paste it to other companies’ column as well to the right.
Now in Y Axis Column enter 100 for all the cells.
In the Market, Labels column enter the below formula and copy to other cells.
Once this table set up a copy the data from I1 to N7.
Once the data is copied select the chart and open paste special dialogue box.
Choose, Categories (X Labels) in First Column.
If you are not getting the chart correctly then download the workbook and change the legends to your cells.
Now finally our Marimekko chart looks like this.
This has been a guide to Marimekko Chart. Here we discuss how to create Mekko chart in excel along with practical examples and downloadable excel template. You may learn more about excel from the following articles –