Marimekko Charts

What is Marimekko Charts?

Disposition of data

Suppose there are four companies, Alpha through Delta, competing in four segments, from A to D, of a specific market. It could be like the Dell, HP, and Toshiba companies competing in the laptop, desktop, and home server segments of the personal computer market. A summary of the data would look similar to this table. The sum of the segment percentages is 100%, and the market segment shares of the companies in each segment (each line) also add up to 100%.

Add tags to the Marimekko Charts

To add segment labels, I use Rob Bovey's free Chart Labeler utility. This utility adds a menu item named "XY Chart Labels" to the Tools menu. It works on any chart type that accommodates chart labels, not just XY charts.

Using the utility, assign the labels in the Labels column to the LabelY series. The labels here have been positioned above the dots.

Peltier Tech Charts was created for Excel 3.0 to develop Marimekko Charts (and many other custom charts) automatically from raw data. This utility, a standard Excel add-in, exposes the data in the required layout and builds a chart with the right combination of chart types. This is a commercial product, tested on thousands of machines in a wide variety of configurations, Windows and Mac, which saves time and aggravation.

System Requirements

Office 365.

Excel 2010, 2013, 2016, and 2019 for Windows (32-bit and 64-bit).

Excel 2016 and 2019 for Macintosh.