I have a hard time explaining this in a single line, so here’s a better explanation (hopefully)
I have some data that looks as follows:
Time Altitude John 10 10 Lisa 10 5 Mona 10 0 John 20 20 Lisa 20 25 Mona 20 40 John 25 40 Lisa 25 55 Mona 25 80
This data series displays the altitude of three people at various times. For example, you can see that John was at an altitude of 10 at time 10, and at an altitude of 40 at time 25. So the label (first column) appears many times with different data points (second,third column) for this label (person in this case).
I want to create a chart from this that looks like this, without having to reformat the data:
So for each row I add to the data table, I specify another (time,altitude) pair for the person name in the first column of the row.
Is this possible?