graphing


P

Paul Hood

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
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Graph within a graph 3
Graphs 1
Graphs 1
Graph Range 2
line graphs 1
Distribution Graph 1
Bar Graph 5
Graphing in EXCEL 1

Top