I have a process that starts with State0, and after some time gets to State1, State2, and so on. Let there be Group1, Group2, Group3, and so on. How can I plot each state for each group having x as the time and y-axis for the Groups?
I would like to plot this example data:
State0 State1 State2 State3 Group1: 0 1 4 8 Group2: 0 3 6 12 Group3: 0 2 5 9 Group4: 0 5 6 7
So each GroupN should be on Y-axis from low to high, and then for each group and state there should be a corresponding scatter point on the time axis. I would like to have each state in different color so one can distinguish the time for StateN.
How can this be plotted in Excel? I have tried several ways but it seems that Excel always takes Groups in x-axis and state in y-axis. Could anyone help me out?
This is the gist of what I'm trying to achieve: