I have been trying for what feels like an eternity to group a bar chart by columns but have not succeeded yet. Basically what I’m trying to do is the following.
I have data that looks like this:
A B C Label
0 1 2 3 ‘0’
1 1.1 2.1 3.1 ‘1’
2 1.2 2.2 3.2 ‘2’
…
N X1 X2 X3 ‘N’
I now would like to have a bar chart with the Labels ‘0’, ‘1’, etc on the x axis where each label is three bars assigned to, namely the bars A, B and C. But with the given grouping options i somehow can not figure out how to accomplish this task. Has anybody an idea?
Thanks alot!