- Say I have a graph with 4 bar charts. When I hover onto it I’d like each bar - e.g student_name - to show the total exams they’ve done and the exam breakdown. For example:
Student1 10
- Biology 2
- Math 3
- English 2
- Chemistry 3
========
Student2 8
- Biology 2
- Math 4
- English 2
=========
Student3 10
- …
How do I do this? And I use MySQL as my DB.
- Second question, how do I change the name of the bar (e.g from Student1 to Andy)
I add table below to clarify my first question:
| ID | Subject | Exams |
|---|---|---|
| Student1 (First Bar) | Biology | 2 |
| Math | 3 | |
| English | 2 | |
| Chemistry | 3 | |
| Student2 (Second Bar) | Biology | 2 |
| Math | 4 | |
| English | 4 | |
| Chemistry | 0 |