This one's got me stumped.

I just officiated a test, and would like to make a chart showing 3 different
pieces of information:

1. The person's name shown horizontally <---
2. The person's score shown vertically |
3. The person's exposure time to the subject, shown by the color of their
bar (ex: green = brand new / black = very experienced, with shades in between)


I know there is a conditional formatting function that does this for cells,
but is there any function that is able to do this for charts, or do I simply
have to go through and hand-pick the color each individual column one by one?

Thanks for your help.