Matrix chart

Synonyms:
Heat map, Marimekko chart, Mosaic chart
matrix_chart.gif

A matrix chart shows relationships between two or more variables in a data set in grid format.

Essentially, the matrix chart is a table made up of rows and columns that present data visually and can be seen as the visual equivalent of a crosstabulation that divides data between the variables. The matrix chart is formed through at least two variables, for the X- and Y-categories. If there is a third or fourth variable, colour or other another dimension can be added to the matrix to represent it.

Examples

Complex matrix chart with individual players listed from p1 to p21 on the y-axis and six attributes such as speed, strength & height on the x-axis

Source: Dave Shellard and Mark Vogelgesan

In this example, we compare players (Y-axis) against six variables on the X-axis. The font is intentionally small because in this example colour was applied to see where individual players stood out. Looking at the rows, the variables in which that player stands out are darker compared to other, weaker stats.

Looking at the columns, players that stand out for a particular variable are easily spotted by the darker color. This matrix chart is accomplished through Conditional Formatting in MS Excel.

Two matrix charts showing that such charts can be laid out vertically as a column chart or horizontally as a bar chart

Source: TechTrax

In this example, the matrix chart is essentially an enhanced column or bar chart where data is presented in proportion to the other values. This example requires some MS Excel work to format the data set correctly (see reference or guide below).

American Society for Quality

In this Matrix chart, simple dots represent the high and low values. The major producers and buyers of a model are identified in the columns. Reading the rows, the trends in model development and purchasing are identified.

Many Eyes: Matrix Chart Guide

More advanced software tools may allow for another dimension, such as this example from Many Eyes. This tool allows for two additional data elements to be shown in pie chart format with in the matrix chart.

Advice for choosing this method

Matrices are useful for visually displaying your crosstabs that can be otherwise overwhelming to read. If you want to publish your crosstab result, consider adding an element of colour or symbol to drive the reader’s attention. With additional software you can make the matrix chart more advanced and show additional variables in a comparative manner.

Advice for using this method

Because so much data is presented in a matrix chart, keep the visual display of the graphs themselves very simple and uncluttered.

If actual data elements are printed, reduce the font size so the colour carries the message.

Resource

Guides

Examples

Many Eyes (2011). Matrix Chart Guide. Retrieved from http://www-958.ibm.com/software/data/cognos/manyeyes/page/Matrix_Chart.html (archived link)

John Peltier (2012). Matrix Chart. Retrieved from http://pubs.logicalexpressions.com/pub0009/lpmarticle.asp?id=508 (archived link)

'Matrix chart' is referenced in: