I have below data in List, I have created a chart where x axis=Loc, y axis=% Done. Now on x axis i want to display data for all quarter for one Loc together. I have tried using groupby on Quarter but it does not display correct chart. Please help.
Quarter Loc Done
1st Nah 0
1st Chu 51
2nd Bee 17
3rd Bee 51
4th Bee 17
1st Cap 17
2nd Cap 0
3rd Cap 17
4th Cap 51
2nd Ber 85
3rd Ber 100
1st Acu 0
1st Alb 100