theta_max

christianp, 10 days ago to random

"It's a simple task," I thought, "don't overthink it, just use a spreadsheet."

I can't work out how to do this: I have two series of height measurements of my kids, along with their ages when the measurements were taken.
How do I plot them both on the same scatter graph, so I can see which kid was taller at any age?

I thought that if I added a column saying which kid each measurement was from, I'd be able to use it to set the marker colour or style, but that doesn't seem to be an option.

Please don't suggest any other tools for this: I'm more than capable of doing it outside a spreadsheet; I just want to know if it's possible in Google Sheets.