Scatter Graphs

[stevejpearson]

Dear all,

I am struggling with Excel 2010 to create a scattergraph showing which grade pupils received in an exam based on their attendance percentage. The attendance percentage should be on the y axis and the grade should appear on the x axis. Each pupil should therefore be identified by one mark on the scattergraph.

My figures are available on the following file:

http://www.box.net/shared/39obzqn0ja

 

[Andrew Poulsom]

To create a scatter chart you need to convert the grades A:F to numbers.

 

[obener]

to be able to do what you want you will have to change results from letters to numbers and then you can remove then number axis and put text labels below the horizontal axis to achive what you want. or you can keep the number axis and put a legend at the side stating 1=a 2=b and so on

 

[stevejpearson]

Thanks for your help - an easy solution and much appreciated.

Steve