I wanted to make a scatter plot with google sheets. I wanted to have one column with dates. Then two or more columns with weights. This is for workouts, lifted weights. And I also wanted to have one column for bodyweight. I did this. It didn't work though. There wasn't data in every column on every date. A lot of empty cells. It seems like google sheets can't handle this, which I think is stupid. Even if the dates are not every day and every date doesn't have data in every column, why couldn't it just draw a scatter plot with the data I give?
