Quadrant chart

Overview

Shaded Quadrant chart is helpful when you want to show in an instance positions or proportions of points in each arbitrary fixed quadrant.

How to create a Quadrant chart?

  1. Add series and perform needed analyses.
  2. Add Scatter chart or Category scatter chart.
  3. On a chart navigate to Actions ribbon to Chart properties > Annotations and add Horizontal line and Vertical line on chart to divide your chart into four areas.
    • You don't have to add it ideally on point. After adding line you can click on it and change its position by typing right value in Line > Position.
  4. Then navigate to Chart properties > Chart ornaments > Text box and add four Text boxes.
    • Note! Text box will push out all other labels (point's labels) because for main-app it's the same type of object - but once you add all four Text boxes, labels will go above Text boxes and you will be able to move them freely.

Setting background colors

This has to be done for each Text box separately:

  1. To add color for Text box click on it, go to Presentation properties and check 'Custom style'.
  2. Click on Presentation properties > Appearance > Background > [...] icon.
  3. By default color is set to 'Solid' - if you don't want to change it, just select colors for quadrants. If you want quadrants to have gradients, change Color type to 'Gradient'.
  4. Select colors, opacity and gradient angle, for example:
    • Left-upper: #99FEA527 60%, #33FFFFFF 20%, angle 60 (orange-white),
    • Right-upper: #99008000 60%, #33FFFFFF 20%, angle 120 (green-white),
    • Left-down: #33FFFFFF 20%, #99B61818 60%, angle 120 (white-red),
    • Right-down: #33FFFFFF 20%, #99DCCD2E 60%, angle 60 (white-yellow).
  5. Under Presentation properties > Border > Border width select 'None'.

Examples

Social Progress Index vs GDP growth

In this example we showed relationship between Brent Oil price and US oil consumption.

Brent Oil Price vs US oil consumption

In this example we showed relationship between Brent Oil price and US oil consumption.

Hit rate

Calculate Hit rate for each quadrant.