Hi Eric,
I've solved the problem created by identical scores.
I've now got a single worksheet with column A for names, up to 20
names.
Columns B to I are for the 8 different sets of scores.
Columns J to Q are all hidden and are helper columns that solve the
duplicate scores problem.
Column S automatically shows the Test 1 scores in order of increasing
size down the column, to the left of it is column R with the names for
those scores.
Then similarly for the other 7 test scores and corresponding names in
column T & U,
V & W, X & Y, Z & AA, AB & AC, AD & AE, AF & AG.
I then have used dynamic named ranges for each of the 8 chart sheets so
that each chart automatically shows the correct number of names on the
horizontal axis, plus the scores occur in increasing order from left to
right.
I've used Conditional formatting to improve the appearance and sheet
protection (no password) to protect the cells with formulas.
I hope to finish sometime tomorrow. Then I'll include a link here if
you are interested.
Thanks for posting your problem it has inspired me to put together a
graphing tool that I will be using myself in my work as a high school
science teacher

Ken Johnson