2. On the worksheet, type 0 in cell B18 and 1 in cell B19. Select the range B18:B19 and drag down the fill handle to cell B1118 to fill a series of numbers from 0 to 1,100.
3. I’m going to represent each quadrant using an Area chart with 1,101 data points each, split in half on each side of the vertical axis—that is, 550 data points on each side of the vertical axis. Therefore, type this formula = (COUNT(B18:B1118) - 1) / 2 in cell D12 to calculate the midpoint.
4. Next, I’ll calculate the size of each square by taking the square root of the relative frequency. Hence, type the following formulas in the respective cells:
C15 --> = SQRT(J5)
D15 --> = SQRT(K5)
E15 --> = SQRT(J6)
F15 --> = SQRT(K6)
5. Next, I need to rescale the size of the quadrants from 0-1 to 0-550 scale. Hence, type this formula = ROUND(C15 * $D$12,0) in cell C16. Then, Copy/Paste cell C16 into cells D16:F16.
6. Next, I need to calculate the limits of each quadrant on the horizontal axis. For example, the upper left quadrant should start at data point 268—that is, the difference between 550 (the midpoint) and 282 (the size of the square). Hence, type the following formulas in the respective cells:
C17 --> = D12 - C16
D17 --> = D12 + D16
E17 --> = D12 - E16
F17 --> = D12 + F16
The worksheet should look like this (by adding some labels):