HI,
I will create a Excel sheet for you with following options.
In settings sheet, you will enter default values for Bad to Good(colors).
Number of tests and test names.
In data sheet, you will enter names of each athlete and their scores per tests.
In chart sheet, it will automatically create charts for each athlete for all tests.
2 versions of chart should be created I think.
First for each individual athlete, their will be chart for their [login to view URL] will show scores of all tests for particular athlete .
Second, to compare each athlete, one chart for each [login to view URL] will show scores of all athletes for any particular test.
In second, you can compare each athlete for any particular test.
We can discuss in more detail of which formats works for you best.
Thanks