How to Make Marimekko Charts in Excel
Marimekko charts, or mosaic plots, allow you to compare categories over two quantitative variables.
In the chart above, column width denotes the energy generated in a state as a proportion of the total energy generated in the US (for example, Texas is, by far, the largest producer). The share of each source by state is displayed along the y-axis. Coal and other Fossil sources are displayed to the bottom in gray, while Nuclear and Renewable sources are displayed to the top in yellowish tones. You can see that, while Texas is the large generator of energy, around two thirds of it is generated from coal and other fossil sources. Illinois, on the other hand, generates more than 50% of its energy from nuclear sources.
So, as you can see, Marimekko charts are some kind of dual stacked bar charts, where you stack categories along both the x- and the y- axes. You can use Marimekko charts in a variety of contexts. You could display the size of sales territories along the y-axis and your product’s market share along the y-axis: do you have significant market shares in large markets? Are your best-performing territories only the smallest ones?
To access this full tutorial and download the source code you must be a member. (If you are already a member, log in here.)
Get instant access to this tutorial and over a hundred more, plus courses, guides, and additional resources.
You'll get unlimited access to hundreds of hours worth of step-by-step visualization courses and tutorials for insight and presentation — all while supporting an independent site. Source code and data is included so that you can more easily apply what you learn in your own work.
The tutorials are very helpful to move from "Oooo, cool!" to how to actually DO the cool.
Members also recieve a weekly newsletter, The Process. Keep up-to-date on visualization tools, the rules, and the guidelines and how they all work together in practice.
See samples of everything you gain access to:
More Tutorials See All →
How to: make a scatterplot with a smooth fitted line
Oftentimes, you’ll want to fit a line to a bunch of data points. This tutorial will show you how to do that quickly and easily using open-source software, R.
How to Make an Animated, Self-Sorting List
You have a list of things that can be ordered by different values. Let them sort themselves out.
Using Color Scales and Palettes in R
Color can drastically change how a chart reads and what you see in your data, so don’t leave it up to chance with defaults.