A Box and Whisker chart can be a useful way to represent a set of marks.
The box represents the range covered by the middle half of the marks (quartile 2 and 3). The whiskers represent quartiles 1 and 4 (the bottom and top quarters). At a glance you can see the range, as well as where most marks are.
Here’s how to create such a graph in Google Sheets.
- Have your set of marks in column A with a heading. In this example the marks go from A2 to A44.
- In B1 have the formula: =min(A2:A44)
- C1: =quartile(A2:A44,1)
- D1: =quartile(A2:A44,3)
- E1: =max(A2:A44)
- Click on cell A1, then go to Insert Chart and under Chart Type choose Candlestick Chart.