Dot Quadrant Chart in QM
Dot Quadrant Chart is an alternative type of data visualization for four KPIs on one common field. Its essence lies in the organization between the main diagonals of a square matrix of four triangular areas with a hundred of cells in each. Each triangular region displays its KPI, with traversal of the cells begins from the vertex of the triangle in the center of the matrix. I put a gray circle symbol into all the cells using the formula, and then I change the color by conditional formatting to the right number of cells proportional to the value of KPI.
Below, I show fictional KPIs in statics and dynamics.
*
*
*
The principle of filling the Dot Quadrant Chart with values in the range [0, 100] is shown below:
*
*
Good luck.
Below is another version of the Dot Quadrant Chart. This time, the matrix cells field is divided into four squares of one hundred cells in each. The principle of symbols shading inside squares is the same as for symbols inside triangular areas (see above).
*
*
*
*
Good luck.
Dot Quadrant Chart by means of Scatter (2D): a Square Shape.
Rather than regular matrices, Scatter (2D) chart is used here as a quad indicator. Plus a little bit trigonometry… and here’s what happened in the end:
*
*
*
*
*
Dot Quadrant Chart by means of Scatter (2D): a Circle Shape.
*
*
*
Nice job!