Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Scatter Chart
I would make a conditional chart with multiple series, one per race. I
describe my method on this page: http://peltiertech.com/Excel/Charts/...nalChart1.html - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Jules" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Line chart or scatter chart?? | Charts and Charting in Excel | |||
Scatter chart displays as line chart | Charts and Charting in Excel | |||
Line chart or scatter chart?? | Excel Discussion (Misc queries) | |||
Line chart or scatter chart?? | Excel Discussion (Misc queries) | |||
scatter chart insists on plotting as a line chart | New Users to Excel |