Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

How to make a chart with sorted values from a column?

Maybe it will be clearer if I explain my use case. As a teacher, I give scores to students ranging from 0 to 20. I made a very simple table with names of the students, their various scores, and finally their average score. If I just take a line, it looks like this (csv style) :

DOE; John; 12; 8; 10;

I would like to display a chart next to this table, showing the average score of every student, but sorted in the ascending order. I know it would be possible to sort the column and then make the chart, but I would have to do this again every time I change or add a score. Is there a way to automatically sort results in the chart without altering the column?