Forcing an xy scattergraph for short columns in Google Sheets
In a data exploration involving hoop rotation period versus diameter Google Sheets does not always produce the desired scatter graph. The issue appears to small sample size or short columns. Spreadsheet Selecting a scatter chart for this data results in the following chart for some students: Note the monotonic spacing on the x-axis. Google Sheets has defaulted to a form of line graph with monotonic spacing on the horizontal axis. To reunite the paired data, select Use column A as label under edit chart on a laptop or desktop computer. Note that this option is not accessible from the Google Sheets mobile app. Of note is that while working inside the Google Sheet chart module in the mobile app the chart appears to configure as expected. Once one exits the chart module, the columns split into two data sets. There is no known easy fix on mobile. The repair essentially requires getting onto a laptop or desktop. There are hackarounds. One is to manually type the data ...