scatter plot

[Jules]

I have a template used to track the scores of grades of students.

This is the raw data (starting in Column A)

Student Form. A MP1 DIFF
A 65 49 -16.00
B 75 85 10.00
C 85 91 6.00
D 55 81 26.00
E 85 90 5.00
F 95 90 -5.00
G 70 78 8.00
H 95 68 -27.00
I 95 92 -3.00
J 80 76 -4.00
K 65 91 26.00
L 65 89 24.00
M 70 87 17.00
N 80 80 0.00
O 90 96 6.00
P 70 81 11.00
Q 95 88 -7.00
R 65 68 3.00
S 70 84 14.00
T 65 79 14.00
U 85 89 4.00
V 95 93 -2.00
w 70 86 16.00
x 65 73 8.00
y 100 92 -8.00
z 75 93 18.00
aa 85 89 4.00
bb 95 60 -35.00


I would like to add a demographic to this, such as race; I thought I would
assign a number to race and was hoping I could have the data point on the
chart change shape according to the code assigned to race.

Would anyone know if this is possible?

Any help is appriciated.

 

[Bernard Liengme]

Let's assume the date is in A129
In column E add the codes you need
Make the Chart from all the data - let's say we have A, B and C students
Move the chart below the data
Select all the data (E1 need some text); use Data | Filter | Auto Filter
Click on E1 and select A code and the chart now has only the A students
best wishes

 

[Herbert Seidenberg]

Or try Pivot Table.
The chart comes free.
Select category on chart.
http://www.freefilehosting.net/download/3afg9