Quad charts are useful because they can section off scatterplots into different areas to highlight different groups of observations. Importance-Performance graphs are a common example of quad charts where you can quickly identify high performing, important brand attributes vs low performing, unimportant brand attributes. Note that since PowerPoint does not have a built-in quad chart type, you must export this type of chart as an image.* This article explains how to add quadrants an array of scatterplots. So you can go from a Bubble chart that looks like:
to one with quadrants like:
Requirements
- A Scatter, Labeled Scatter, Bubble, or Labeled Bubble visualization. See How to Create a Scatter Plot for detail on how to create any type of scatterplot.
Method
- In order to export the quadrants along with your scatterplot you must choose Appearance > PowerPoint Export > Format > Image on the visualization.*
- Select the visualization and from the object inspector, check Chart > Quadrants > Show Quadrants.
- Select where you want the horizontal and vertical lines to go in your chart. The Set midpoint on X/Y axis using fields determines how this is done. Average and Median are options automatically calculated using the observations. Calculation will point to a Calculation output where you can create a custom calculation to use. Value allows you to enter a static value to place the line. This example uses the Average for both the X and the Y axis.
- Optional: Further customize the horizontal and vertical lines for the width, color, and type (style).
- Optional: Four new sections are created when using quadrants to format the individual quadrants if desired: Top Left, Top Right, Bottom Left, and Bottom Right Quadrant. Within each, you can set the background color, add a title, and customize the title font.
- Optional: You can reposition the quadrant titles (as well as other labels) on the chart. This positioning will be remembered if the visualization is recalculated, but reset if the data used in the visualization changes.
* If you export the visualization as an editable chart, the only way to add in quadrants is manually by using shapes.