Dot Quadrant Chart in QM

116 viewsTips and Techniques
0

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.

Answered question

Nice job!

0

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.

Answered question
You are viewing 1 out of 1 answers, click here to view all answers.