Quadrant Bubble Chart in Excel

Use QI Macros to create a Quadrant Bubble Chart

Quadrant Bubble Charts show any cause-effect relationships between three variables.

To create a Quadrant Bubble Chart using QI Macros, highlight your three columns of data:

quadrant-bubble-data

Then select "Box, Dot & Scatter Plot" > Quadrant Bubble:

quadrant-bubble-menu

Next, you will be asked to input the point at which the Y-Axis crosses the X-Axis and the X-Axis Crosses the Y-Axis - this creates your quadrant. Note that we also identify potential crossings for you:

y-cross-x-prompt

x-crosses-y-prompt

A Quadrant Bubble Chart will then be created:

quadrant-bubble-chart

Learn More...

To create a Quadrant Bubble Excel using QI Macros...
Try It Now!