Create a matrix plot of each Y vs each X with overlaid groups

If you want your matrix plot of each Y vs each X to include groups, you can display them overlaid on the same graph.

For example, this matrix plots displays a plot for each possible pairing of the response variables (Sales and Rate of Return) vs the predictor variable (Years in business) for three groups of manufacturing companies.

To create a matrix plot of each Y vs each X with groups, you must use a worksheet that contains multiple columns of X and Y data and at least one column of categorical data for grouping.

Example worksheet

C1 C2 C3 C4
Sales Rate of Return Years Group
50400200 15.4 18 1
42100650 11.3 15 2
39440420 9.9 12 2
... ... ... ...
  1. Choose Graph > Matrix Plot.
  2. Under Each Y versus each X, choose With Groups, then click OK.
  3. Under Y variables, enter one or more response variables. In the example, Sales and Rate of Return are the y variables.
  4. Under X variables, enter one or more predictor variables. In the example, Years is the x variable.
  5. Under Categorical variables for grouping (0-3), enter one or more columns of categorical data. In the example, Group is the categorical variable for grouping.
  6. Click OK.
By using this site you agree to the use of cookies for analytics and personalized content.  Read our policy