Scattergram

  • Thread starter Thread starter JohnM
  • Start date Start date
J

JohnM

Hi,
I'm struggling with what should be simple. A scattergram
showing students results of tests in relation to
predictions. Spreadsheet has 3 columns Name, Test result,
prediction. Aiming to get x axis Test result y axis
prediction. each student plotted as a point!

I get some pretty bizarre results!

John
 
Thanks, but unfortuantley, the best I get is where one
axis shows the students, and two points are created, one
for Test and one for Prediction. I'm looking for Test
being one axis, prediction being the other, and one point
at the relevant position for each student. This differs a
little from the example in the wizard.
John M
 
Bernard implied, don't select the column with the student names. Just select the numerical
columns and make your chart. Then you can use Andy's suggestion if you want to label the points
with the student names.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
 
Back
Top