To create a scatterplot with connect lines and groups, complete the steps for the option that best describes your data.
Complete the following steps if your groups are defined by values in a grouping variable, or unique combinations of values in multiple grouping variables.
In this worksheet, Time is the Y variable and Year is the X variable. Race is the categorical variable for grouping. The graph shows the winning times for each race by year, with connect lines.
Complete the following steps if you have multiple pairs of numeric or date/time columns and each pair is a group.
In this worksheet, 100m is the first Y variable and Year is the corresponding X variable. 200m is the second Y variable and Year is the corresponding X variable. Each set of Y and X variables forms a group. The graph shows the winning times for the 100m and 200m races over time, with connect lines.