I have a student data with Student Name and their grade (A/B/C/D/E.). Now I want to have a graph for this data.
Kindly help me.
I have a student data with Student Name and their grade (A/B/C/D/E.). Now I want to have a graph for this data.
Kindly help me.
Open Ms Excel, select the column student name and grade, go to insert option click on chart tab, under that you will find create chart option under that choose whatever template you want and do whatever editing you want to do...
If you want to assign grade(A/B/C/D), I don't think its possible...You can assign A as 1, B as 2 and so on...
I had an idea: first calculate numeric grades into a new column,
the formula in that column would be =5-(CODE(C2)-CODE("A"))
...
and then set a custom formatting on the axis, to [=5]"A";[=4] "B";[=3]"C";[=2]"D";[=1]"E";"-"
... but I cannot get this to work in LibreOffice,
it USES at most three "conditions", where the last doesn't seem to check the condition inside the brackets.
The help section on the web doesn't say that there is a limit.
Now it might be that Excel does this correctly.
Example data, and a right click on the char Y-axis showing the menu:
And here is the format setting: