Dear Excel Folks,
I am trying to create a worksheet to show trends in students performance in a fitness test. I want to display icons to show whether their present attempt was better, in line with or worse than their previous effort.
So for example if score 2 was better than score one it would display an upward arrow, if it was the same it would be a flat arrow and if worse than the score before it would be a downwards arrow
I also want to show this as a sparkline at the end to show their overall trend in their performance.
Is there a way of using icon sets to compare their score against the previous score?
<tbody>
</tbody>
Many Thanks
I am trying to create a worksheet to show trends in students performance in a fitness test. I want to display icons to show whether their present attempt was better, in line with or worse than their previous effort.
So for example if score 2 was better than score one it would display an upward arrow, if it was the same it would be a flat arrow and if worse than the score before it would be a downwards arrow
I also want to show this as a sparkline at the end to show their overall trend in their performance.
Is there a way of using icon sets to compare their score against the previous score?
Name | Score 1 | Score 2 | Score 3 | Score 4 | Trend (Sparkline) |
Student 1 | 1.1 | 1.3 | 1.7 | 1.4 | |
Student 2 | 2.2 | 2.2 | 2.7 | 3.1 | |
Student 3 | 1.8 | 2.3 | 2.2 | 2.1 |
<tbody>
</tbody>
Many Thanks