I have been asked to make graphs of some evaluation forms, however I don't see how to make readable graphs with the data they gave me:
Every group has its own little table with data, the graph they want is an overview of how often each grade has been given.
For each group we want two stacked column charts, one per category. In which each part of the stack is the amount each grade is given. Something like this:
(though ignore the line), but then with two columns per group.
Eventually more groups will be added and they have to be added to the charts as well, with minimum work.
I'm working in excel 2013.