Is it possible to create a plot of a 2x2 matrix?

[cnbingham]

I have 2-dimensional qualitative data that I want to plot on a 2x2 (or 4 quadrant) chart

                 Axis 1         Axis2
Option 1:    +                 -
Option 2:    =                 -
Option 1:    -                 +
Option 1:    =                 =

Where + is positive, = is parity, - is negative. Has anyone tried to do such a thing before?

Thanx tons,

Curtis

 

[Jon Peltier]

Put some real values into the table:

              X     Y
Option 1:     1    -1
Option 2:     0    -1
Option 1:    -1     1
Option 1:     0     0

Select the data, create an XY chart. Double click on the X axis, set the minimum=-2, maximum = 2, major unit = 2, Y Value axis crosses at 0. Double click on the Y axis, set the minimum=-2, maximum = 2, major unit = 2, X Value axis crosses at 0. The axes will serve to divide the chart into quadrants.

You could construct a combination chart if you wanted to display differently formatted quadrants:

http://peltiertech.com/Excel/Charts/ColoredQuadrantBackground.html