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

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.

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 |

... | ... | ... | ... |

- Choose .
- Under Each Y versus each X, choose With Groups, then click OK.
- Under Y variables, enter one or more response variables. In the example, Sales and Rate of Return are the y variables.
- Under X variables, enter one or more predictor variables. In the example, Years is the x variable.
- 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.
- Click OK.