Hi everyone,
I have a set of academic scores data that categorized into grades A (>85), B(>70), C (>55), D (>40), E (40 and below).
Any idea how could I plot a chart in Excel (perhaps line chart with marks?) showing the grades but not the actual score values?
I am using Excel 2010.
Test No. || Scores || Grades
1 || 60.5 || C
2 || 71.2 || B
3 || 54.0 || D
4 || 71.5 || B
5 || 80.0 || B
6 || 86.5 || A
7 || 30.9 || E
8 || 38.3 || E
9 || 41.0 || D
10 || 57.4 || C
Many thanks in advance,
PicardV
I have a set of academic scores data that categorized into grades A (>85), B(>70), C (>55), D (>40), E (40 and below).
Any idea how could I plot a chart in Excel (perhaps line chart with marks?) showing the grades but not the actual score values?
I am using Excel 2010.
Test No. || Scores || Grades
1 || 60.5 || C
2 || 71.2 || B
3 || 54.0 || D
4 || 71.5 || B
5 || 80.0 || B
6 || 86.5 || A
7 || 30.9 || E
8 || 38.3 || E
9 || 41.0 || D
10 || 57.4 || C
Many thanks in advance,
PicardV
