Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
graphing
Hi all,
I would like to plot points on a graph. On the horizontal axis I would like a students actual score and on the vertical axis the predicted score and the intersection of these points plotted in the graph area. So that if for example all of the pupils get their predicted scores there would be a straight line diagonally across the graph. If any pupil did better than than predicted they would fall below the line and any doing worse would come on top of that line. eg 10 9 8 7 6 c 5 b 4 3 2 a 1 1 2 3 4 5 6 7 8 9 10 person a was predicted to get 2 but got 3 person b was predicted to get 5 but got 1 and person c was predicted to get and got 6 Is there any way excel can do this? Hope you can help |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
graphing
OOps silly me a scatter graph of course!!
"Paul Hood" wrote in message ... Hi all, I would like to plot points on a graph. On the horizontal axis I would like a students actual score and on the vertical axis the predicted score and the intersection of these points plotted in the graph area. So that if for example all of the pupils get their predicted scores there would be a straight line diagonally across the graph. If any pupil did better than than predicted they would fall below the line and any doing worse would come on top of that line. eg 10 9 8 7 6 c 5 b 4 3 2 a 1 1 2 3 4 5 6 7 8 9 10 person a was predicted to get 2 but got 3 person b was predicted to get 5 but got 1 and person c was predicted to get and got 6 Is there any way excel can do this? Hope you can help |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Graphing | Excel Discussion (Misc queries) | |||
HELP WITH GRAPHING PLEASE!!! | Excel Discussion (Misc queries) | |||
Graphing R=1+E | Excel Discussion (Misc queries) | |||
graphing | Excel Discussion (Misc queries) | |||
graphing | Excel Discussion (Misc queries) |