I wonder about my approach to make a chart with glide.
I would like to display per pupil (E1-E2 etc) their number of speeches during the cycle (column data (S1 S2 S3 … S10)
is my goggle sheet design correct
That might work with the Bar Chart and save on rows. Generally the glide charts work better with data in rows instead of columns. You would probably get more flexibility if you had only 3 columns. One for Pupil, one for Cycle and one for Count. Then using relations or filters, you can control which student is displayed in a chart.