Marimekko Chart Excel

The result is shown below.

Once, we get the percentage sales of sales data for each company, to create a mekko chart we need to create that many rows for each company, i.e. For the company sun pharma, I have created 50 rows because the percentage share is 50, similar number of rows is created based on the percentage sales of each company so, the total hundred rows created, after this, I have to add the respective company distribution share for each company across different rows.

So, the total rows will be 100 rows data, now for this set of 100 rows, we have to create a 100% stacked bar chart under the 2d column chart option in the chart tab.

Now, once the 100% stacked bar chart is created, we have to format it

There is a gap between data series in the stacked bar chart, we have to format it, where we need to remove the gap width across data bars, by clicking on anywhere in data bars, and right-click on it, in that select an option format data series, where we need to update the gap width percentage from 150 to 0%

Once the gap width is updated to 0%, below mentioned changes can be observed in the chart.

In the X-axis, you can observe the multiple similar names of company in the chart, it is because the no. of rows appears in the data table i.e. 50 rows in case of sun pharma. we can update it to single company name record, by keeping it at a middle portion and deleting the other records in the data table, to perform this we need to delete the multiple similar names of the company and restricting it to a single entity in the data table.

Once the X-axis parameters are resolved, the data bars need to be formatted, where you can observe the sales data for each segment of one company is overlapping on each other (Below mentioned screenshot), now we need to get rid of this by creating boundaries across each company sales segment separately.

Boundaries across each company sales segment can be created with the help of inserting lines across each company borders.

Under the illustration, you need to select a shape, under that click on a Line. now that line appears in the chart area, where you need to format it and place it across each company border in the data bars.

I need to draw the line across the border of the data bar for a sun pharma company and need to format it.

Now, the line background color needs to be updated or formatted from black to white color under the shape outline option.

For a better appearance of the line across the border, we need to increase its weightage to 2^1/4 points under the shape outline options.

Once the line is formatted, we can copy and paste across each company data bar borders. I have removed the default Chart Title and changed it to the relevant title.

Now, the Marimekko chart is ready, where the bar width reflects or indicates each company sales performance in comparison to the other competitor companies for a given drug class segment and column height represents the sales in that particular drug class segment for the individual companies.

Things to Remember About Marimekko Chart Excel

• Marimekko chart is primarily used for market analysis, i.e. market segmentation, % share of competitor companies in a market segment & individual share of companies in a market segment.
• There are a various third-party utility or add-in tool & Power-user available in the market to automatically create a Marimekko chart by just inputting the raw data or variables most commonly used is Peltier Tech Charts for Excel 3.0
• Marimekko chart provides valuable input with a single chart, which helps the client with clear insight for future planning and executing it for improvement in company sales performance.

Recommended Articles

This is a guide to Marimekko Chart Excel. Here we discuss How to Create Marimekko Chart in Excel along with practical examples and downloadable excel template. You can also go through our other suggested articles –

1. SEARCH Formula in Excel
2. Excel NORMSINV Function
3. Name Box and its Uses in Excel
4. Concatenate Strings in Excel