google sheetsgoogle-sheets-charts
I have data that looks like this:
Name X Y
Bob 0 15
Bob 3 20
Bill 0 24
Bill 5 30
And so on. Basically I want to have a line for Bob, a line for Bill, etc. With X as the X-axis. (Note that their X values aren't exactly the same)
The actual data set I'm working with is huge so the options of manually adding the ranges are difficult.
Is there an easy way to get Google Sheets to produce that graph?
To get the desired result edit your chart and change the type to Scatter and uncheck the Use column A as labels.
My understanding of your requirement is as below, though this does not apply your sample data:
The layout of the left four columns is required - in effect I have substituted:
10 100
30 110
60 150
80 180
for your sample data in the OP.
I selected the data area, Charts, Charts, Line and checked both Use row 1 as headers and Use column A as labels. This ended up with the appearance of a scatter plot but in Advanced edit..., Customise, Features this, oddly, was fixed by checking Plot null values.
The colours, datapoints etc were customised for the image.
Best Answer
Your dataset would need to look like this if that's what you are after: