I am having challenges creating a side by side bar chart with the following data
Name Gender Grade1 Grade2 Grade 3
John M B A C
Mary F B A B
Peter M C B B
Susan F B C B
Mike M A C B
The chart should show a summary by gender for Grade1, Grade2 and Grade3. For example
the 1st column Male, Grade1 should represent the letter A and have a value of 1
the 2nd column Female, Grade1 should represent the letter A and have a value of 0
the 3rd column Male, Grade1 should represent the letter B and have a value of 1
the 4th column Femaleale, Grade1 should represent the letter B and have a value of 2
the 5th column Male, Grade1 should represent the letter C and have a value of 1
the 6th column Female, Grade1 should represent the letter C and have a value of 0
the 7th column Male, Grade2 should represent the letter A and have a value of 1
the 8th column Female, Grade2 should represent the letter A and have a value of 1
It would also be nice to have a total count for each grade.
IP Logged