Mosaic Chart aka Marimekko Chart

A Mosaic chart / Marimekko chart is really just a stacked column chart.

Mosaic charts / Marimekko charts convert data points into percentages and plot them as a bar chart. You can draw this kind of chart in Excel using the stacked column chart.

mosaic-chart marimekko chart

In the example above, a restaurant owner wants to know if the type of music playing in the background affects the type of wine purchased by customers.

In this case, Italian music increases Italian wine purchases (center bar) and French music increases French wine purchases (bottom right bar), but I find this format difficult to analyze. Some argue that this is a form of chart junk that hides the information needed to make good decisions.

Pareto Chart Alternative to a Marimekko Chart

Instead of creating a mosaic plot, we could select the data:

mosaic-chart-marimekko-data

And run Pareto charts using the QI Macros:

multiple-pareto-charts

From these three charts, it's easy to see that the Other and French Paretos are pretty flat, meaning that music may have little or no impact on the wine selected. If we look at the Italian wine (middle Pareto), however, Italian music has a significant impact on whether or not Italian wine is chosen. French music effectively kills Italian wine sales.

If we look at total wine sold, no music or Italian music sells about 12% more wine than French music:

excel-pareto-chart

This isn't evident from the Mosaic plot.

Here's My Point

There's more than one way to display data on charts. Trying to cram everything onto one chart can make it hard to decipher and hide critical information. When in doubt, use multiple charts to make the case clearly.

Create these charts and diagrams in just seconds using QI Macros for Excel...