Marimekko Charts

Stacked column charts are commonly used to display proportions of data across different categories. While the height of each stack is proportional to the breakdown of the data in one dimension, standard stacked charts have uniform column widths. A Marimekko chart, also called a matrix chart, enhances a stacked column chart by making the column widths or bar heights proportional to another variable.

This page describes the rearrangement of data required to construct and label a Marimekko chart in Excel.

PTS Marimekko Chart Utility

In this page I have described a technique for constructing Marimekko charts in Excel. I have also developed the PTS Marimekko Chart Utility that allows the user to construct Marimekko charts charts directly from the data; the utility rearranges data in the table and then creates and formats the chart from this table. The utility is designed to work in Excel for Windows versions 2000, 2002, and 2003, and 2007. The utility has not been tested in any Macintosh version or in Excel 97; it is not expected to work in these versions.

Top of Page