Charts & Data Visualization
Quadrant Chart (2x2 Matrix) Formula: Crosshair-Centered XY & Quadrant Classifier
Build a 2x2 Strategic Quadrant Scatter Chart (BCG Growth-Share, Value-vs-Effort, Price-vs-Quality) by centering coordinates at origin (X - X_cut, Y - Y_cut) so plot axes form natural crosshairs and classifying items into Q1–Q4.
Center XY coordinates on your benchmark cutoffs so the chart’s (0, 0) axes draw automatic 2x2 crosshairs!
In product management (Impact vs Effort), portfolio strategy (BCG Market Growth vs Relative Share), and supplier scorecards (Quality vs Cost), a 2x2 Quadrant Chart partitions items around horizontal cutoff X_cut (mean, median, or target threshold) and vertical cutoff Y_cut! Subtracting the cutoffs — X_centered = X_i - X_cut and Y_centered = Y_i - Y_cut — shifts the decision crosshairs directly onto Cartesian origin (0, 0), so any Scatter chart’s native X = 0 and Y = 0 axes divide the four quadrants automatically without brittle manual shapes!
Simultaneously, nested IF logic classifies every item deterministically: Q1 Top-Right (X >= X_cut, Y >= Y_cut: High X / High Y), Q2 Top-Left (X < X_cut, Y >= Y_cut: Low X / High Y), Q3 Bottom-Left (X < X_cut, Y < Y_cut: Low X / Low Y), and Q4 Bottom-Right (X >= X_cut, Y < Y_cut: High X / Low Y)!
| Portfolio Quadrant (Cutoffs X_cut, Y_cut) | Coordinate Sign (X_c, Y_c) | Impact (Y) vs Readiness (X) Action |
|---|---|---|
| Q1: Top-Right (X >= X_cut, Y >= Y_cut) | (+, +) | Priority Scale / Strategic Stars |
| Q2: Top-Left (X < X_cut, Y >= Y_cut) | (-, +) | High-Impact Bets (Build Readiness) |
| Q3: Bottom-Left (X < X_cut, Y < Y_cut) | (-, -) | Deprioritize / Sunset |
| Q4: Bottom-Right (X >= X_cut, Y < Y_cut) | (+, -) | Quick Tactical Maintenance |
2x2 Strategic Quadrant Classifier (Q1, Q2, Q3, Q4)
Compares item X score (B2) and Y score (C2) against benchmark medians/targets AVERAGE($B$2:$B$5) and AVERAGE($C$2:$C$5).
=IF(B2 >= AVERAGE($B$2:$B$5), IF(C2 >= AVERAGE($C$2:$C$5), "Q1: Top-Right (High X, High Y)", "Q4: Bottom-Right (High X, Low Y)"), IF(C2 >= AVERAGE($C$2:$C$5), "Q2: Top-Left (Low X, High Y)", "Q3: Bottom-Left (Low X, Low Y)"))Crosshair-Centered Horizontal Coordinate X_centered = X_i - X_mean
Computes signed horizontal distance from portfolio mean AVERAGE($B$2:$B$5) so X_centered = 0 marks the vertical quadrant divider.
=ROUND(B2 - AVERAGE($B$2:$B$5), 2)Try the example
Use the original values or change them to test your understanding.