google sheetsgoogle-sheets-charts
I have a table with X-Y values for two types of measurements, I want to draw two graph lines on a chart for each of the type (without modification of data in the sheet)
| x-values | y-values | type |
|---|---|---|
| 0 | 5 | A |
| 0 | 6 | B |
| 1 | 3 | A |
| 1 | 2 | B |
alternative would be to use 2columns table, but I would have to transform data from source which i would like to avoid
| x-values | y-Avalues | y-Bvalues |
|---|---|---|
| 0 | 5 | 6 |
| 1 | 3 | 2 |
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.
Please try with layout as shown. Select A1:C11 (or to suit), insert Line chart with Use row 1 as headers and Use column A as labels:
Best Answer
Choose Insert > Sheet and put this formula in cell
A1of the new sheet to pivot the data the way need:Then insert a chart based on the data in the new sheet.