I'm an inexperienced student using google sheets for my lab report. In the following data, each row represents data for each of 4 people: xi (columns B-E) represents a position in meters, and ti (columns F-I) represents the time at which each person is at position xi.
I want to create a scatter plot with the x axis being time and the y axis being position. Each point should have coordinates (xi, ti), and data points from different people should have different colors. How should I achieve this?