Spreadsheet: 93698d1293452684-set-up-pivot-chart-with-multiple-years-copy-of-sample
Sheet: Sheet4

Year of Entry | (All)
Class | Level | Data | Total
English | Advanced | Count of 2001 | 6
 |  | Count of 2002 | 7
 |  | Count of 2003 | 10
 |  | Count of 2004 | 16
 |  | Count of 2005 | 17
 |  | Count of 2006 | 31
 |  | Count of 2007 | 20
 | Honours | Count of 2001 | 3
 |  | Count of 2002 | 5
 |  | Count of 2003 | 6
 |  | Count of 2004 | 13
 |  | Count of 2005 | 12
 |  | Count of 2006 | 22
 |  | Count of 2007 | 23
 | Introduction | Count of 2001 | 5
 |  | Count of 2002 | 5
 |  | Count of 2003 | 5
 |  | Count of 2004 | 9
 |  | Count of 2005 | 9
 |  | Count of 2006 | 19
 |  | Count of 2007 | 15
English Count of 2001 |  |  | 14
English Count of 2002 |  |  | 17
English Count of 2003 |  |  | 21
English Count of 2004 |  |  | 38
English Count of 2005 |  |  | 38
English Count of 2006 |  |  | 72
English Count of 2007 |  |  | 58
French | Advanced | Count of 2001 | 2
 |  | Count of 2002 | 4
 |  | Count of 2003 | 5
 |  | Count of 2004 | 11
 |  | Count of 2005 | 12
 |  | Count of 2006 | 15
 |  | Count of 2007 | 19
 | Honours | Count of 2001 | 3
 |  | Count of 2002 | 7
 |  | Count of 2003 | 8
 |  | Count of 2004 | 11
 |  | Count of 2005 | 15
 |  | Count of 2006 | 22
 |  | Count of 2007 | 20
 | Introduction | Count of 2001 | 5
 |  | Count of 2002 | 9
 |  | Count of 2003 | 8
 |  | Count of 2004 | 20
 |  | Count of 2005 | 16
 |  | Count of 2006 | 27
 |  | Count of 2007 | 22
French Count of 2001 |  |  | 10
French Count of 2002 |  |  | 20
French Count of 2003 |  |  | 21
French Count of 2004 |  |  | 42
French Count of 2005 |  |  | 43
French Count of 2006 |  |  | 64
French Count of 2007 |  |  | 61
German | Advanced | Count of 2001 | 4
 |  | Count of 2002 | 6
 |  | Count of 2003 | 7
 |  | Count of 2004 | 13
 |  | Count of 2005 | 15
 |  | Count of 2006 | 26
 |  | Count of 2007 | 26
 | Honours | Count of 2001 | 4
 |  | Count of 2002 | 5
 |  | Count of 2003 | 9
 |  | Count of 2004 | 14
 |  | Count of 2005 | 16
 |  | Count of 2006 | 26
 |  | Count of 2007 | 24
 | Introduction | Count of 2001 | 3
 |  | Count of 2002 | 3
 |  | Count of 2003 | 5
 |  | Count of 2004 | 8
 |  | Count of 2005 | 11
 |  | Count of 2006 | 18
 |  | Count of 2007 | 19
German Count of 2001 |  |  | 11
German Count of 2002 |  |  | 14
German Count of 2003 |  |  | 21
German Count of 2004 |  |  | 35
German Count of 2005 |  |  | 42
German Count of 2006 |  |  | 70
German Count of 2007 |  |  | 69
Math | Advanced | Count of 2001 | 8
 |  | Count of 2002 | 8
 |  | Count of 2003 | 13
 |  | Count of 2004 | 19
 |  | Count of 2005 | 18
 |  | Count of 2006 | 28
 |  | Count of 2007 | 23
 | Honours | Count of 2001 | 2
 |  | Count of 2002 | 6
 |  | Count of 2003 | 8
 |  | Count of 2004 | 14
 |  | Count of 2005 | 11
 |  | Count of 2006 | 19
 |  | Count of 2007 | 22
 | Introduction | Count of 2001 | 5
 |  | Count of 2002 | 7
 |  | Count of 2003 | 6
 |  | Count of 2004 | 11
 |  | Count of 2005 | 12
 |  | Count of 2006 | 23
 |  | Count of 2007 | 18
Math Count of 2001 |  |  | 15
Math Count of 2002 |  |  | 21
Math Count of 2003 |  |  | 27
Math Count of 2004 |  |  | 44
Math Count of 2005 |  |  | 41
Math Count of 2006 |  |  | 70
Math Count of 2007 |  |  | 63
Science | Advanced | Count of 2001 | 4
 |  | Count of 2002 | 7
 |  | Count of 2003 | 8
 |  | Count of 2004 | 12
 |  | Count of 2005 | 11
 |  | Count of 2006 | 24
 |  | Count of 2007 | 18
 | Honours | Count of 2001 | 2
 |  | Count of 2002 | 5
 |  | Count of 2003 | 7
 |  | Count of 2004 | 10
 |  | Count of 2005 | 12
 |  | Count of 2006 | 19
 |  | Count of 2007 | 19
 | Introduction | Count of 2001 | 2
 |  | Count of 2002 | 4
 |  | Count of 2003 | 7
 |  | Count of 2004 | 13
 |  | Count of 2005 | 12
 |  | Count of 2006 | 22
 |  | Count of 2007 | 22
Science Count of 2001 |  |  | 8
Science Count of 2002 |  |  | 16
Science Count of 2003 |  |  | 22
Science Count of 2004 |  |  | 35
Science Count of 2005 |  |  | 35
Science Count of 2006 |  |  | 65
Science Count of 2007 |  |  | 59