Want a Quadrant Bubble Chart in Excel?
QI Macros can create a Quadrant Bubble Chart for You!
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:
Then select "Box, Dot & Scatter Plot" > Quadrant Bubble:
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:
A Quadrant Bubble Chart will then be created:
