AJP Excel Information

Tile chart

The chart displays a matrix. The colour of the tile represents the value at each intersection. 

The chart is constructed from a combination of Bar, Column and XY-Scatter. The Bar and Column chart are used to provide category axis labels. The tiles are derived from the XY-scatter chart.
The chart uses data from conditional formula in order to display a single tile in each position.

The workbook contains a step by step explanation on how to construct the chart.