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

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

Follow these steps if your worksheet contains 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 With Groups, 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.
- In Categorical variables for grouping (0-3), enter one or more columns of categorical grouping variables. In the example, Gender is the categorical variable for grouping.
- Click OK.

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 With Groups, 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.
- Check X-Y pairs form groups.
- Click OK.