Hi
I am trying to develop a spreadsheet for a school to track pupil progress against the key stage levels, the data is collected as a point score per pupil and then manually converted to a level i.e. a level 2a is 17 point, level 2b is 19 points, 2c is 21 points and 3a is 23 points etc. I have no problem in generating nice 3-D charts with pupil across the X axis and the value up the Y-axis but the school would like to see the charts display level instead of the points score. I am using Vista and XP with Office/Excel 2007 and so far I can't seem to find a way to do this. Has anybody found a simple way to use labels for the Y axis, based on value range ?
Any help much appreciated
John
I am trying to develop a spreadsheet for a school to track pupil progress against the key stage levels, the data is collected as a point score per pupil and then manually converted to a level i.e. a level 2a is 17 point, level 2b is 19 points, 2c is 21 points and 3a is 23 points etc. I have no problem in generating nice 3-D charts with pupil across the X axis and the value up the Y-axis but the school would like to see the charts display level instead of the points score. I am using Vista and XP with Office/Excel 2007 and so far I can't seem to find a way to do this. Has anybody found a simple way to use labels for the Y axis, based on value range ?
Any help much appreciated
John