The setup log compares crew size with time spent in one room. In A1:B5 enter Team size, Setup minutes, then the pairs 2 and 40, 3 and 34, 6 and 27, and 10 and 26.

Keep the X values numeric

In Ulet select A1:B5 and choose Insert → Scatter. Label the X axis with people and the Y axis with minutes. If you see positions 1 through 4, inspect which source column supplies X and confirm it contains numbers.

Four records pair team sizes 2, 3, 6 and 10 with times 40, 34, 27 and 26.

Illustrated source log. Each row supplies both coordinates.

Read one dot back to the log

Find the observation at X = 6 and Y = 27. Check that the interval from 6 to 10 is wider than 2 to 3. Reopen the saved XLSX and confirm both axes and the data mapping. The points describe these four setups. Room layout or crew experience could also explain the pattern.

The scatter plot highlights the six-person setup at 27 minutes.

Illustrated chart check. The gap from X = 6 to X = 10 is four times the gap from X = 2 to X = 3.

Related Microsoft Excel reference