Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Set | Name | Score |
1 | A | 10 |
1 | B | 12 |
1 | C | 15 |
2 | A | 9 |
2 | B | 14 |
2 | C | 16 |
3 | A | 12 |
3 | B | 14 |
3 | C | 13 |
4 | A | 11 |
4 | B | 12 |
4 | C | 14 |
My data is like this every week i run the script it will add scores for A,B,C as a new set. i.e when i run this week it add "Set" as 5 for each of A,B,C and their scores. Now what i need is a bar chart showing height as score and only taking last 3 weeks i.e when i run this week since it will be set 5 it should take set's 5,4,3 and give grouped bar charts by name.
u can try using wildmatch
Hello thanks for the reply. Can you also explain how i can get the change in the last two sets i.e between 4 and 3 keeping in mind that next week it will be 5 and 4 and will keep changing? and graph this change as Name vs change
The graph will ajust to the three OR two latest Sets with the expressions below. If you add another set 5, the graph will adjust.