Create a matrix of plots with overlaid groups

If you want your matrix of plots to include groups, you can display them overlaid on the same graph.

For example, this matrix of plots displays a plot for each possible pairing of Sales, Rate of Return, and Years in business, for three groups of manufacturing companies.

To create a matrix of plots with overlaid groups, your worksheet must contain multiple columns of measurement data and at least one column of categorical data for grouping. All columns must have the same number of rows.

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 Matrix of plots, choose With Groups, then click OK.
  3. Under Graph variables, enter multiple columns of numeric or date/time data. In the example, Sales, Rate of Return, and Years are the graph variables.
  4. 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.
  5. Click OK.
By using this site you agree to the use of cookies for analytics and personalized content.  Read our policy