You can create a graph like the following example using data arranged in different layouts in the worksheet.

To create a scatterplot with groups on separate panels, choose the layout option that is similar to your worksheet.

Follow these steps if your worksheet contains at least one pair of columns of X-Y data and at least one column of categorical data for grouping.

C1 | C2 | C3-T |
---|---|---|

Height | Weight | Gender |

66.0 | 140 | M |

61.0 | 140 | F |

72.0 | 160 | M |

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

- Choose .
- Choose Simple, then click OK.
- Under Y variables, enter a column of y-values. In the example, Weight is the Y variable.
- Under X variables, enter a column of x-values. In the example, Height is the X variable.
- Click Multiple Graphs, then click the By Variables tab.
- In By variables with groups in separate panels, enter the categorical grouping variable. In this example, Gender is the categorical grouping variable.
- Click OK in each dialog box.

Follow these steps if your worksheet contains multiple pairs of columns of X-Y data, and each X-Y column pair is a group.

C1 | C2 | C3 | C4 |
---|---|---|---|

Height Male | Height Female | Weight Male | Weight Female |

66.0 | 61.0 | 140 | 140 |

72.0 | 65.0 | 160 | 135 |

74.0 | 61.5 | 190 | 108 |

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

- Choose .
- Choose Simple, then click OK.
- Under Y variables, enter a column of y-values. In the example, Weight Male is the Y variable.
- Under X variables, enter a column of x-values. In the example, Height Male is the X variable.
- Repeat steps 3 and 4 for each additional pair of X-Y variables. In the example, Weight Female is the second Y variable and Height Female is the second X variable.
- Click Multiple Graphs.
- Under Show Pairs of Graph Variables, choose In separate panels of the same graph.
- Click OK in each dialog box.