Hi everyone. I’m trying to create a simple graph (using the Bubble Chart Element plugin), but I’m pretty new to graphing and am hoping someone can help.
I’m a teacher, my graph tracks student marks per week. So if a student got 2 in week 1 then I’d like the week 1 column to have a height of 2. Easy enough so far, I’ve got that working.
The challenge I’m facing is I’d like for weeks where no data is found to be displayed as a zero on the graph. I don’t add marks of zero (it would be cumbersome to have to go through give zeros for every student who hasn’t earned a mark). But this means the graph just skips that week currently.
So if a student got the following marks:
Week 1: 3
Week 2: 2
Week 3: Absent (no mark)
Week 4: 4
I’d like a graph showing bars of height 3,2,0,4.
Is there any way to achieve this?
My data structure is simple enough. I have a data type Student Marks with 3 fields: Student, Mark (the numerical value), and Week.
Additionally (but less important) I’d like the graph to always show 10 weeks (1 term), so for weeks yet to happen I’d like them to display as zero as well, until marks are earned.