Thread: Scatter Chart
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
Jules Jules is offline
external usenet poster
 
Posts: 86
Default Scatter Chart

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.
--
Jules