I have a rather complicated Excel question that I hope someone can understand and help with. I have a set of data in three columns, the first is an (institution) name, the second and third are two pieces of numeric data about each institution (called X and Y, see below for an example of the data). I want to produce a scatter plot of X versus Y for each institution, or rather, I want to do this lots of times for different groups of institutions, data etc. The only way I have managed to create the scatter plot successfully is by selecting the individual cells for Name, X and Y values in step 2 of the chart wizard. This is very time consuming and I'm looking for a quicker way of completing this task. I can easily plot X vs Y as a single data series but cannot label the points by their institutional names, I can also create multiple named series but with the plotting as X1 vs X2,3,4 & Y1 vs Y2,3,4 etc. instead of X1 vs Y1, X2 vs Y2 etc. If anyone has any suggestions they would be most welcome.
Anglia Polytechnic University 97 8
Cranfield University 88 13
Norwich School of Art & Design 99 5
University of Cambridge 55 1
University of East Anglia 87 5
University of Essex 94 7
University of Hertfordshire 96 7
University of Luton 98 9
Writtle College 89 6
ES Average 83 6
Sorry, can't tell you what the figures actually mean (at least not 'til they're officially released next week, anyway, I might have changed a few
)
