scatter plot

  • Thread starter Thread starter Jules
  • Start date Start date
J

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.
 
Let's assume the date is in A1:D29
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
 
Back
Top